Aging bucket creation

Navyasree123

Hi all ,hope doing great ,I have query regarding aging bucket

I have aging days based on days we need to calculate the aging bucket

For example:

Aging days	Aging bucket
1	1-30
31	31-60
61	61-90
91	91-360
361	+365

 If the aging days is 1450 then aging bucket is +365

what condition i want use in this case.

cjaneczko

Try this. Aging days should be set to Double.

IF [Aging days] <= 30 then '1-30'
elseif [Aging days] <= 60 then '31-60'
elseif [Aging days] <= 90 then '61-90'
elseif [Aging days] <= 360 then '91-360'
elseif [Aging days] >= 361 then '+365'
else ''
endif