In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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