Dynamic Aging Buckets in Webi

[Former Member]

Dear Sateesh Kumar

Dynamic Aging Buckets in Webi

Please help, as you mentioned I need to have "Aging Days (Difference between 2 dates Due date and current date) "

I have Due Date, but I did not have the date desired for the cutoff date.

How to add this date to the report? Regards

[jyothirmayee_s]

Hi,

CurrentDate() is a Date function that is available in WebI.

This date gives your System date. Try the below formula to give you number of days between Due Date and Current Date.

=Daysbetween([DueDate],CurrentDate())

Thanks,

Jothi