Filter tool Malformed if statment

I have several columns of data and I'm trying filter out if each column of the line has all zeros but I'm getting a malformed if statement parse error. Column headings =

F CL Begin Bal PTD

F CL Additions PTD

F CL Releases PTD

F CL Ending Bal

Filter tool: If statement = If [F CL Begin Bal PTD] = 0 AND [F CL Additions PTD] = 0 AND [F CL Releases PTD] = 0 AND [F CL Ending Bal] = 0

I'm sure I'm missing something at the end but not sure what that is.

Thanks!

Error Message

Parse

Accepted answers

atcodedog05

Hi @CherieACI

Just try

[F CL Begin Bal PTD] = 0 AND [F CL Additions PTD] = 0 AND [F CL Releases PTD] = 0 AND 
[F CL Ending Bal] = 0

and check

Adding brackets is also good idea.

([F CL Begin Bal PTD] = 0) AND ([F CL Additions PTD] = 0) AND ([F CL Releases PTD] = 0) 
AND ([F CL Ending Bal] = 0)

You dont need if statement in filter tool

Hope this helps 🙂

All comments

atcodedog05

Hi @CherieACI

Just try

[F CL Begin Bal PTD] = 0 AND [F CL Additions PTD] = 0 AND [F CL Releases PTD] = 0 AND 
[F CL Ending Bal] = 0

and check

Adding brackets is also good idea.

([F CL Begin Bal PTD] = 0) AND ([F CL Additions PTD] = 0) AND ([F CL Releases PTD] = 0) 
AND ([F CL Ending Bal] = 0)

You dont need if statement in filter tool

Hope this helps 🙂

CherieACI

Yes, that worked! Thank you so much!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703