Question:
Hi All,
I have net due date in cube level ,
At query level , i want sys date and
calculate ageing ==> sys date - due date
and split amount values based on ageing <30 , >=30 etc..
I search in this forum , but i couldn't get what i want..
Appreciate ur detail explaination .
Answer:
Create a variable of type user-exit, or use an standard one. Fill it with SY-DATUM.
In query, create a calculated key figure. Create another variable of type replacement path. Fill it with the date in record.
Your calculated key figure is the substraction of the two variables.
I have used it and it works.
Probably you will need also a counter of records, to avoid the summation of days and calculate an average.
Regards.
Answer:
Thanks for ur response.
i got confused some where ...
1). net due date drag to rows
2). created calculated key figures which displays current date
3). how to subtract these 2 ?
if i tried create formula , i would see only key figures.
please explain step by step process
Answer:
No.
You don't need to see dates in reporting.
In your calculated key figure (calculation before aggregation), create a formula variable, type replacement path, replace by value of characteristic NET DUE DATE.
Substract from this variable another formula variable, type user-exit, filled with SY-DATUM.
For every record involved in the report, you will get the difference in days.
Regards.