Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Aging bucket creation

Navyasree123
8 - Asteroid

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
11-30
3131-60
6161-90
9191-360
361+365

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

what condition i want use in this case.

 

 

2 REPLIES 2
cjaneczko
13 - Pulsar

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_0-1687351941843.png

 

Navyasree123
8 - Asteroid

@cjaneczko Thank you

Labels
Top Solution Authors