Skip to Content
0
Jul 30, 2008 at 06:43 PM

Date difference calculation with user input variable

27 Views

Hi,

I have the following requirement in BEx:

The user inputs a date value and I have to calculate the difference between the date entered by the user with the Due Date in the cube, to determine the number of backlog days. Basically, I need to calculate Past Due in number of days. I need to display the Amount due for the Time buckets like 1 -10 days, 11 -30 days.

The report output has to be in the format below:

Columns:

1 u2013 10 days Past Due $100.00

11 u2013 30 days Past Due $15.00

Rows:

Customer#

The cube has data from Jan 2005 to June 2008.

For Eg: User Input Date = 04/30/2008.

It should compare the input date to the due date for each record in the cube.

Any suggestions are appreciated.