IF c THEN t ELSE f ENDIF with RIGHT function

[Keilynbarrera]

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

[AngelosPachis · Accepted 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

[Qiu · Accepted solution]

@Keilynbarrera 

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.

[Keilynbarrera]

Thanks! That solved it!

[Qiu]

@Keilynbarrera 

Glad to help and thank you for the accept mark. 😁