Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

IF formula with >= zero issue

sydowa
5 - Atom

if [Account] = "1501" AND [End Bal Accounted] >= "0" then"Line 34" else"Line 32" endif

 

I have prepared the formula above, however all results default to "Line 32". I know my ending balances in account 1501 are both positive and negative. Am I not entering the >=0 correctly? The [Account] is a V_String and the [Ending Bal Accounted] is a double? 

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor

Hi @sydowa 

 

If End Bal is a double then you don't need quotes:

if [Account] = "1501" AND [End Bal Accounted] >= 0 then"Line 34" else"Line 32" endif

binuacs
21 - Polaris

@sydowa I guess your Account is string type and End balance is numeric, in that case try the below formula

 

if [Account] = “1501” AND [End Bal Accounted] >= 0 then"Line 34" else"Line 32" endif

sydowa
5 - Atom

thank you for your help! 

Labels
Top Solution Authors