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
Solved! Go to Solution.
Hi @Learner09 ,
Is it you who built this formula ? Can you explain the logic behind it ?
Cheers,
Jean-Baptiste
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
Thanks! will wait for your reply with workflow example
Thanks a lot, Jean !
Its working. Can i send some other questions to you if i have ?
Best,
Mayank
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