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 %]] 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

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

Expression

Data Investigation

Accepted answers

binay2448

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]

All comments

binay2448

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703