If statement to select a range

julianhoetzel

Hi everyone, 

I am pretty new to Alteryx. So I hope someone can me out 🙂

How can I write an IF Statement with the following conditions:

I need to determine the scores that match with "Share of total payables aging". 

For instance, "Sum not due" which is 1.41 is supposed to have a score of 600 since it is way above the 0.125 threshold whereas "Sum_due within 30 days" (-0.359) is supposed to have a score of 100 since it is below 0.00.

Can someone help me? Thank you 🙂

Screenshot 2020-12-21 152404.png

messi007

@julianhoetzel,

I updated the input with 0.06,

Correct me if I'm wrong. If it's 0.06 it have to be 400 as it's between 0.05 and 0.075.

Please see below

I'll let you update the formula below:

if IsNull([Share of payables aging])
then 0
elseif [Share of payables aging]<=0 
then [1] //it's the first scroe
elseif [Share of payables aging]>0 and [Share of payables aging]<=0.025
then [2]
elseif [Share of payables aging]>0.025 and [Share of payables aging]<=0.05
then [3]
elseif [Share of payables aging]>0.05 and [Share of payables aging]<=0.075
then [4]
elseif [Share of payables aging]>0.075 and [Share of payables aging]<=0.1
then [5]
else [6]
endif

Attached the workflow,

If this solves your issue please mark the answer as correct, it will help others!

Regards,

CRA Question.yxmd