Filter by multiple criteria

!IsNull([Assignment])
AND
[GLAccount]=("0044574098")
AND
[GLAccount]=("0044574099")

I keep getting zero true results when I add the second GL criteria, However if I do just one or the other it runs fine. Does anyone have a better way? I want only those two accounts to populate

Parse

Help

Accepted answers

echuong1

The criteria is looking for a record to have both of those account numbers. Try this:

!IsNull([Assignment])
AND
([GLAccount]=("0044574098")
OR
[GLAccount]=("0044574099"))

All comments

echuong1

The criteria is looking for a record to have both of those account numbers. Try this:

!IsNull([Assignment])
AND
([GLAccount]=("0044574098")
OR
[GLAccount]=("0044574099"))

BrandonB

It is impossible for the same cell to be two separate GL Accounts simultaneously. I would recommend changing it to the following:

!IsNull([Assignment])
AND
([GLAccount]=("0044574098")
OR
[GLAccount]=("0044574099"))

BrandonB

@echuong1 you are lightning fast to those responses!🙂

JVM15

Thanks for the assist!

MarqueeCrew

@JVM15 ,

I prefer IN statements:

!IsNull([Assignment])
AND
[GLAccount] IN ("0044574098", "0044574099")

cheers,

mark

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335