IF Function based on percentage

Question

Hi Alteryx Community,

I am really struggling with a formula and need your help/suggestion for it.

Query is- If missed savings is less than 20.00%, it is COMPLIANT and if greater than 20.00% then non-compliant. 1 thing to make sure is criteria should be exact 20.00%.

Kindly help!

Thanks

sheetalk1234 · Answer

Thank you so much, this clears my doubt! :)

MRod · Answer

This depends on how you label when it's equal to 20.00%.  If 20.00% is considered compliant then the following should work:

if [Savings]<=.2 then "Compliant" else "Non-Compliant" endif

If considered not-compliant then you can remove the = sign. Additionally, if you want to have an additional label for exact matches you can add an elseif :

if [Savings]<.2 then "Compliant" elseif [Savings]=.2 then "Exact" else "Non-Compliant" endif

*Assuming Savings is numeric. Please see screenshot of test variables.

20231014.PNG