user input selection based on Keyfigure

[former_member603578]

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,

[anshu_lilhori · Accepted solution]

This message was moderated.

[former_member603578 · Accepted solution]

It worked. Thanks a lot Anshu..

[KodandaPani_KV]

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.

[former_member603578]

Hi Kodandapani,

I have already calculated the difference between the dates.

The issue is user needs a selection variable  based on this difference between the dates. Like, if user gives 1 day for the selected date range, the output should display the values which falls on 1 day only.

[KodandaPani_KV]

Hi,

user need difference days as a variable am i correct?

other create the variable on the Processing date, Issued Date using between condition.

if you run the query on the variable user will give the Processing date, Issued Dates values.

Thanks,

Phani.

[former_member603578]

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.