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.
Solved! Go to Solution.
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
@cjaneczko Thank you