Filter true condition

[Grace4889]

Basic question here..

I'm using the following expression to only show rows with data that have a numeric value of either 96 or 98, but the output data still generate rows that contained other numeric values. 

[GLDataType] = 96 OR 98

What am I doing wrong.

[flying008]

Hi, @Grace4889 

If  [GLDataType] field type not string, then 

[GLDataType] = 96 OR [GLDataType] = 98

but in some case, you need try the condition: 

tostring([GLDataType]) = "96" or tostring([GLDataType]) = "98"

[binuacs]

@Grace4889 @You can also write the formula like below

[GLDataType] IN (96, 98)