Hello,
I'm trying to use the formula too to return lines of data where th.e GLAccount numbers have the last three digits equal '037' or '041' but my formula turns black once I add in "else Null() Endif". Also I am getting a Malformed State error. Anyone see any reason this formula should not work? My data type is Int32.
IF Right([GLAccount], 3) in ('037', '041') THEN -[FunctionalAmount] else Null() ENDIF
Solved! Go to Solution.
Hi @Keilynbarrera ,
The Right function can only be used with String data type fields.
Can you try adding the GL account to a ToString function?
IF Right(Tostring([GLAccount]), 3) in ('037', '041') THEN -[FunctionalAmount] else Null() ENDIF
Cheers,
Angelos
As @AngelosPachis pointed out, the Right and In function only work for string type data.
and we can also use the contain function for your purpose here.
Thanks! That solved it!
Glad to help and thank you for the accept mark. 😁