Multiple Statements in a formula

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!

Preparation

Accepted answers

Hollingsworth

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","")

All comments

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

I agree with @Luke about the parenthesis match

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

bman213

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703