how to filter multiple column which contains 0

[Beckyli]

how to filter multiple columns that contains 0, 

when there is 0 on Beginning balance, Endding Balance and Transaction columns at same time then no need show up.

i use formula "and" it doesn't work.

[MilindG]

[binuacs · Accepted solution]

@Beckyli your formula seems to be correct. Make sure that the fields are numeric in the data type

IF they are not numeric try the below formula

toNumber([Begining Balance]) !=0
AND
toNumber([Ending Balance]) != 0
AND
toNumber([Transactions]) !=0

[Beckyli · Accepted solution]

i need use "and" not "or", but anyway doesn't work for me either.

[Beckyli]

why my keep getting error.

[MilindG]

@Beckyli  You have beginning misspelled