Need Help in Building formula

[Learner09]

Below is the excel formula

IF(AY3="SFW",IF(AD3<2500,"0-2500 EE",IF(AD3<5000,"2501-5000 EE",IF(AD3<10000,"5001-10k EE",IF(AD3<20000,"10001-20K EE",IF(AD3<50000,"20,001-50K EE",IF(AD3<100000,"50,001-100K EE","999,999 EE")))))),"")

I need to build the same formula in Alteryx. Please assist me

[Jean-Balteryx]

Hi @Learner09 ,

Is it you who built this formula ? Can you explain the logic behind it ?

Cheers,

Jean-Baptiste

[Learner09]

Hi Jean-Balteryx

I am trying to add column in my analysis 'customer category' - on the basis to license count (AD) for those customers who have "SFW" i.e. Software :

SFW software

if Lic count is 80 then it should come under 0-2500EE range

if Lic count 5250 that should come under range of 5001-10k and so on.

Thanks

[Jean-Balteryx]

@Learner09 ,

I'll build an example workflow and send it to you !

Cheers,

Jean-Baptiste

[Learner09]

Thanks! will wait for your reply with workflow example

[Jean-Balteryx · Accepted solution]

@Learner09 ,

Here it is !

Ask me if you have any question !

Cheers,

Jean-Baptiste

[Learner09]

Thanks a lot, Jean !

Its working. Can i send some other questions to you if i have ?

Best,

Mayank

[Jean-Balteryx]

@Learner09 ,

My pleasure !

Yes of course you can. The best is to create one post per question, so if anybody is looking for the same thing he will find it easily.

Cheers,

Jean-Baptiste