Community
I am trying to create an if statement using the Expression Builder.
The syntax is:
If ( [condition], [trueValue], [falseValue] )
I have entered:
If ( OWNER_ID = 10, 'COVAV' , 'Other' )
OWNER_ID is an integer. I have tried other fields that are strings and putting quotes around the test, but nothing works. I get:
The expression is invalid
Error: Argument types for function 'If' are mismatched. Click here to move the cursor to the error (3)#3
Error: Result types are mismatched: the validation operation expected 'Boolean' but the expression returned 'Unknown'
Thanks