Hi Team,
Hope you are well.
I need help. I have this excel function which i need to replicate into alteryx. Can you please help?
thanks
IF(B3="BELOW THRESHOLD STABLE",0,IF(B3="ABOVE THRESHOLD STABLE",1,IF(B3="ABOVE THRESHOLD FLAG",2,0)))+IF(C3="BELOW THRESHOLD STABLE",0,IF(C3="ABOVE THRESHOLD STABLE",1,IF(C3="ABOVE THRESHOLD FLAG",2,0)))+IF(D3="BELOW THRESHOLD STABLE",0,IF(D3="ABOVE THRESHOLD STABLE",1,IF(D3="ABOVE THRESHOLD FLAG",2,0)))+IF(E3="BELOW THRESHOLD STABLE",0,IF(E3="ABOVE THRESHOLD STABLE",1,IF(E3="ABOVE THRESHOLD FLAG",2,0)))+IF(F3="BELOW THRESHOLD STABLE",0,IF(F3="ABOVE THRESHOLD STABLE",1,IF(F3="ABOVE THRESHOLD FLAG",2,0)))+IF(G3="BELOW THRESHOLD STABLE",0,IF(G3="ABOVE THRESHOLD STABLE",1,IF(G3="ABOVE THRESHOLD FLAG",2,0)))+IF(H3="BELOW THRESHOLD STABLE",0,IF(H3="ABOVE THRESHOLD STABLE",1,IF(H3="ABOVE THRESHOLD FLAG",2,0)))
I would like to create the column I ,"Weighted Score" in the below excel file.
Please find attached,
Thanks,
Solved! Go to Solution.
Hi @sriniprad08
You can transpose it, apply the condition and summation it. Like below
Hope this helps : )
I've done basically the same as @atcodedog05 but with a lookup table for the values instead of the formula
Hi @atcodedog05 ,
Perfect. Thank you so much is it also possible to color the fields like a heat map for e.g
Wherever its Below Threshold then it should be colored Green. etc.
Please let me know
thanks,
@sriniprad08 To get background colors you'll need to use a table tool with column rules, see attached. I've set conditions on the first two columns, they will need adding to the others too.
Hi @Christina_H ,
Thank you . Amazing. I was about to paste this question. How to set the rule please?
Thanks,
Sri