Aging for Finance dashboard

Hi Guru,

I’ve calculated date difference between 2 dates in Webi.
Now I want to do, aging group for that dates( 0-30days,31-60,61-90 etc)
Kindly help.
Thanks,
Jopice
[/img]
Webi data for aging.JPG


joice.samuel (BOB member since 2014-10-28)

Search for BUCKET in this forum. Eg: Buckets are not working

Basically you create a variable: If value <= 10 then group1 if value <= 20 then group2 if value <= 30 then group3 etc

Debbie


Debbie :uk: (BOB member since 2005-03-01)