Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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
Free Trial

Bengaluru, IN

Welcome to the Bengaluru User Group

Click in the JOIN GROUP button in Home to follow our news and attend our 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