Click in the JOIN GROUP button in Home to follow our news and attend our events!
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
Try this
IF[sum of transactions] = "0" then "pair off" else "outstanding" endif
@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!
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.