Alteryx Designer Desktop Discussions

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

Malformed If Statement

JoseMignone
7 - Meteor

Hi there, can someone please help me finding the error in this formula? I just can´t see it.

 

IF [Tipo]="A" AND (ABS([Q1])>9000 OR ABS([Q4])>9000) AND ABS([Diferencia USD])>9000 THEN "Analyze" ELSE IF [Tipo]="B" AND (ABS([Q1])>9000 OR ABS([Q4])>9000) AND ABS([Diferencia USD])>9000 THEN "Analyze" ELSE "OK" ENDIF

 

Thanks in advance,

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

IF [Tipo]="A" AND (ABS([Q1])>9000 OR ABS([Q4])>9000) AND ABS([Diferencia USD])>9000 THEN "Analyze" ELSEIF [Tipo]="B" AND (ABS([Q1])>9000 OR ABS([Q4])>9000) AND ABS([Diferencia USD])>9000 THEN "Analyze" ELSE "OK" ENDIF

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels