Multiple Statements in a formula

[bman213]

Hi all,

I am hoping someone can help. I ma trying to create a formula that selects multiple arguments for one output, but I ma struggling some.

IF [STATUS_1] = "C" AND([OPERATED] = "YES" AND !isnull([DATEOPERATED]) AND [TURN_COUNT] > 0 THEN "C"
ELSE "" ENDIF

So if the (status1, Operated, Dateoperated and Turn Count > 0) THEN "C"

Thanks in advance!

[Luke_C]

Hi @bman213 

I think you either need to close the parenthesis you opened after 'And([Operated]...' or remove it. 

IF [STATUS_1] = "C" AND([OPERATED] = "YES" AND !isnull([DATEOPERATED]) AND [TURN_COUNT] > 0) THEN "C"
ELSE "" ENDIF

[Hollingsworth · Accepted solution]

I agree with @Luke about the parenthesis match

you can also try the iif syntax which I like for conciseness:

- with parenthesis
iif( [STATUS_1] = "C" && ([OPERATED] = "YES" && !isnull([DATEOPERATED])) && [TURN_COUNT] > 0,"C","")
- OR without parenthesis
iif( [STATUS_1] = "C" && [OPERATED] = "YES" && !isnull([DATEOPERATED]) && [TURN_COUNT] > 0,"C","")

[bman213]

Thanks to both of you guys, it is this community that really makes Alteryx so beneficial. Appreciate the help!