Current Position:Home > How to use formula variable to calculate the days for a document.

How to use formula variable to calculate the days for a document.

Update:11-30Source: network consolidation
Advertisement
Hi expert.
I have a question, I need to calculate how many days it cost for a document, therefore , it should be like this,
cost days = clearing date - creation date..
how can I implement this calculated key figure by formula variable..
Here cost days should be a key figure, but the clearing date and creation date are the characteristics in the document.
it seems that formula variable by replacement path can not be used, do I have to use the customer exit for this variable ??
any other good ways to calculate the cost days (beside during the data loading or by virtual key figure).
I just want to implement this in the query designer..
Please give a detailed steps if you could,  thanks a lot.

The Best Answer

Advertisement
Hi,
These steps below are for the query designer in BI 7.0:
1. First create a Formula in the Columns.
2. Edit the formula, in the "Available Operands" see for the "Formula Variable".
3. Right Click on the "Formula Variable" folder and then create a new variable.
4. Edi the Formula Variable in the edit screen provide the Description and Technical name; select the processing by as Replacement path.
5. In the reference characteristic select your characteristic "Creation Date".
6. Save the variable.
7. Select the variable into the formula and name the formula as Creation Date.
Repeat the Same steps for the "Clearing Date".
Then create another formula for the Cost days in which you mention as Clearing date (Formula) - Creation Date (Formula).
Hope your issue is solved...
Regards,
Ravi Kanth
  • How to use formula variable to calculate the days for a document. Update:11-30

    Hi expert. I have a question, I need to calculate how many days it cost for a document, therefore , it should be like this, cost days = clearing date - creation date.. how can I implement this calculated key figure by formula variable.. Here cost day

  • User Exit Formula Variable - to calculate #days of any month Update:11-30

    Hello Team, I need a column in my report layout which shows the #days of any month entered by the user. User entry 01.2014 to 03.2014 report should have 31 28 & 31 according to the Calendar month in the rows. To achieve this I'm using a user exit for

  • Formula variable using Replacement path not working Update:10-11

    Dear All, I am using a query to calculate YTD values in the report. I am using a formula variable to calculate the number of months. Formula is Month To - Month From+1 When I am giving the range from 001 to 006 for period in th evariable screen, I am

  • Formula Variables and their use Update:11-30

    I have a scenario where I have a date selection using a variable. I get from and to date defaulted to 1st day of the month and current date Next, I created a formula variable to calculate the difference between these 2 dates. I can't uses replacement

  • SAP Bex: How to calculate formula variable, without dragging corresponding date in the row Update:11-30

    Hi Experts, In my requirement, we should not do any changes in the BW system. I need to create a Bex query on the existing Info-set, KPI need to be calculated from the date objects. e.g Delivery date - Order date - which has been done with the formul

  • Formula variable with replacement path on system date Update:10-11

    Hi Experts, I got a requirement to calculate "Days without payment" in report level. Days without payment = System Date - Payment Date. (Payment date field is available in CUBE, but system date field is not available in the CUBE) As we know, the

  • Formula Variable in WAD (Counts) Not Displaying Update:10-11

    Hi Gurus, I am using BI7.0.  I have a query that analyzes a charactersitic, such as Priority, uses 2 date (charactersitic[Create Date and Close Date) fields.  I created a new forumla variable, using a Replacement path, to calculate the difference bet

  • Formula variable not displayed in proper format Update:10-11

    Hai,      I used a keyfigure formula variable, that gets current date, in a query (In columns, key figure structure to calculate no. of days). The no. of days are calculated peoperly and everything is just perfect. But after executing the query, when

  • Difference between Formula, Formula Key Figure & Formula Variable Update:11-30

    Hi Experts, I have a basic question in my mind: 1) What is the difference b/w Formula, Formula Variable, Formula Key Figure? 2) What is the difference b/w Selection, Filter and Restriction? Can you pls explain with some scenarios? That will be helpfu

  • How to create formula variable on system date. Update:11-30

    i want to calculate inventory age as on today. i have create formula variable on inventory creation date. i want to create <b>formula variable on system date.</b>simply create a formula variable and set the processing to "by user exit&quo