The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Bangalore, IN

Welcome to the Bangalore User Group

Click the 'Join Group' button to get updates on group news and events.

Multi conditional statement

Neeta_Latwal
7 - Meteor
‎03-06-2024 05:07 AM

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

Reply
3 REPLIES 3
s_koovery
5 - Atom
‎03-06-2024 05:37 AM

Try this

 

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

 

Reply
vkand5
5 - Atom
‎03-06-2024 05:37 AM

@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!

Reply
kamal03
9 - Comet
‎03-06-2024 08:56 AM

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.

Reply
industry user group interest form