user input selection based on Keyfigure
Need your inputs to the below situation.
We have a report which calculates the difference between processing date and issued date. These dates are calculated in BEx as below.
Processing date = Date where status is E0023
Issued Date = Date where status is E0045
Difference in Days = Issued Date - Processing Date
Now, the issue is user wants a selection variable on the " Difference in Days". Based on the user input like 1 day, 2 days etc, the output should be calculated. Request you to put your thoughts on this.
Anshu Lilhori replied
Dinakar,this is very much possible.As far as i understand you need to create a variable on difference which must be a keyfigure.
You need to create a condition.There you may choose the keyfigure on which you need a variable--Operator will be equal to--Then select variable entry--Create a new variable--Variable will be of type formula and in dimension choose number.
For complete walk through you can refer the below document.
Hope this helps.