multiple number filters

[ntudev]

why isn't my filter formula not working?

[Profit Center Number] in ('73','30')

am i doing this wrong?

[binu_acs · Accepted solution]

@ntudev Check your data type of the field profit centre number whether it is numeric or string type?

[Felipe_Ribeir0]

Hi @ntudev 

Your formula is correct, i think that the problem here is the data type of the column. Take a look at the data type of the Profit Center Number column.

If Profit Center Number is a string

[Profit Center Number] in ('73', '30')

If Profit Center Number is a number

[Profit Center Number] in (73, 30)

I attached one example for you.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.