Skip to Content

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,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 14, 2014 at 06:32 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 13, 2014 at 11:29 AM

    Hi,

    you can create the 2 formula variables on 2 date fields Processing date, Issued Date

    type of variable is the formula variable and processing method is - replacement pant.

    if you converting the char to KF you can easily calculate the difference days.

    in rows panel put the Processing date, Issued Date then run the query in RSRT or bex analyzer.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Yes..user wants to give difference in days as variable. User also provides the values for date with which the processed and issued dates are derived.

      Is it possible to provide difference in days as input and the output can be controlled based on that.