Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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