IF c THEN t ELSE f ENDIF with RIGHT function

Question

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 Answer

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 Answer

@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.