Hello, I was wondering if anyone could help me with this. I am using the formula tool to apply the following formula to a column, however im receiving an error:
IF IsEmpty ([PARTY TYPE])= 1 THEN "Entity" ELSEIF [PARTY TYPE]=2 THEN "Individual" ELSE "Investigation" ENDIF
Can anyone please help
Hi @keithr197 ,
The ISempty function does not need and =1 sign after it so that's probably what's causing the error. Try
IF IsEmpty ([PARTY TYPE]) THEN "Entity" ELSEIF [PARTY TYPE]=2 THEN "Individual" ELSE "Investigation" ENDIF
Hope that helps, let me know if that worked for you.
Cheers,
Angelos
Ah I see @keithr197 ,
That error is probably because the [Party Type] field is a string, but you're comparing it against a numeric value. Try wrapping the 2 in quotation marks, so
[Party Type]="2"
or
you can convert the field [Party Type] into a number just for this expression by using the ToNumber function, so
ToNumber([Party Type])=2
Hope that does it.