Multi conditional statement

[Neeta_Latwal]

Hi All,

Please help with the function in alteryx

If sum of transactions is 0 then i want Pair off else Outstanding

IFF[sum of transactions] = "0" than "pair off" else "outstanding"

But this is not working in alteryx.

Thanks,

Neeta

[s_koovery]

Try this

IF[sum of transactions] = "0" then "pair off" else "outstanding" endif

[vkand5]

@Neeta_Latwal  I see that the formula has THAN instead of "THEN". Can you correct it and check? If it is still not solving, please send a sample dataset to help you debug.
Thanks!

[kamal03]

Hi @Neeta_Latwal 

Please try this formula

IIF([sum of transactions]= 0, "pair off", "outstanding")

Note: If the sum of transaction is double don't use ( " " ) in comparison.