Creating Calculated Field

[sriniprad08]

Hi Team,

Hope you are well. I need help in creating the calculated field based on the certain conditions.

1) Current Status (Column N) in the below snapshot.

     Formula -> IF([@[June Count Full Access %]]<5%,"BELOW THRESHOLD","ABOVE THRESHOLD")

2) Average Status (Column O) in the below snapshot,

     Formula -> IF(N2="BELOW THRESHOLD", "STABLE", IF(M2>10%, "FLAG", "STABLE"))

3) KRI weight (Column P) in the below snapshot,

     Formula - > [@[Current Status]]&" "&[@[Average Status]]

Please find attached the snapshot of the data and 

Thank you for the support,

Regards

Sri

[binay2448 · Accepted solution]

1) Current Status (Column N) in the below snapshot.

     Formula -> IF [June Count Full Access %]< 5% then "BELOW THRESHOLD" else "ABOVE THRESHOLD" endif

2) Average Status (Column O) in the below snapshot,

     Formula -> IF N2 ="BELOW THRESHOLD" then "STABLE" else IF M2 >10% then "FLAG" else "STABLE" endif endif

3) KRI weight (Column P) in the below snapshot,

     Formula - > [Current Status]] + " " + [Average Status]

[sriniprad08]

Thank you @binay2448 . Very helpful. one question please how can we show % next to a number in alteryx in a if else statement

thanks

[atcodedog05]

Hi @binay2448 

Change 5% to "5%" or 0.05

Hope this helps : )

[sriniprad08]

@binay2448   Thank you. The second conditions doesn't seem to work correctly. Can you please let me know if this is correct?

2) Average Status (Column O) in the below snapshot,

     Formula -> IF N2 ="BELOW THRESHOLD" then "STABLE" else IF M2 >10% then "FLAG" else "STABLE" endif endif

Actual results is

When i run the below formula it results in all of them "Flag"

IF [Current Status] ="BELOW THRESHOLD"
then "STABLE"
else IF [Average Full Access %] > "10%"
then "FLAG" else "STABLE" endif endif

Please let me know your thoughts,

thanks

[atcodedog05]

Hi @sriniprad08 

try this

IF [Current Status] ="BELOW THRESHOLD"
then "STABLE"
else IF [Average Full Access %] > 10
then "FLAG" else "STABLE" endif endif

[sriniprad08]

Hi @atcodedog05 ,

Thank you for the help. Sorry but it's not working. Giving the same result.

[atcodedog05]

Hi @sriniprad08 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.