Replicating excel formula in Alteryx

[sriniprad08]

Hi Team,

hope you are well. 

I need help. I need to replicate the excel formula in alteryx.

Please find attached the input and output.

The calculation for 

1) Avg column- Average of all the three months (But has to be dynamic) for eg. in future if i need to calculate for 2 months then it has be average of last 2 months.

2) Threshold - (IF([@[Average Full Access %]]>10%,"ABOVE THRESHOLD","WITHIN THRESHOLD"))

3) Trend - IF(OR([@[May Count Full Access %]]<10%,[@[June Count Full Access %]]<10%),"RECOVERING AND WITHIN TOLERANCE","INCREASING UPPER LEVELS OF TOLERANCE") - Here the month has to be dynamic because in future it will be based on 2, 3 or 4 or 6 months.

Please let me know how to go about it,

thanks

[sriniprad08]

Hi @atcodedog05 ,

Thank you for all the support. I have a question please in the attached file the highlighted row in yellow is not calculating properly.

Please find below the actual formula in excel to be replicated in Alteryx.

IF(OR(Base_month_plus_0<85%,Base_month_plus_1<85%),"RECOVERING AND WITHIN TOLERANCE","INCREASING UPPER LEVELS OF TOLERANCE")

Please let me know your thoughts,

Thanks ,

Sri

[sriniprad08]

Hi @atcodedog05 ,

Please let me know your thoughts,

Thanks

Sri

[atcodedog05]

Hi @sriniprad08 

In the previous post your condition was And

[Base_month_plus_1]<3 and [Base_month_plus_2]<3 

Now its or 

OR(Base_month_plus_0<85%,Base_month_plus_1<85%)

Thats why its not working

[atcodedog05]

Hi @sriniprad08 

Try this workflow

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you for the reply. Actually there are different metrics and this is one of them.

By taking the max_value doesnt work if it's a OR condition correct?

Base_month_plus_0 - 25

Base_month_plus_1 - 85

Base_month_plus_2 - 35

Base_month_plus_3 - 40

Base_month_plus_4 - 95

Please let me know your thoughts,

Thanks

Sri

[atcodedog05]

Hi @sriniprad08 

Thats correct we need to use min in case of OR.

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you so much :). 

Cheers

Sri

[atcodedog05 · Accepted solution]

Happy to help : ) @sriniprad08 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!