Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

user input selection based on Keyfigure

Hi All,

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.

Regards,

Former Member
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.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d072bd5c-09ad-2d10-eb8c-8164271dfa0f?QuickLink=index&…

Hope this helps.

Regards,

AL

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question