Is ther a way to "OR" filters?

demtat

Is there a way to "OR" filters in NAV? I need a filter to test that one of two fields has been entered (is not blank).

kapamarou

If you mean something like showing the entries that have Debit Amount <> 0 OR Credit Amount <> 0 then no.

You will need to apply the first filter, check what you need, the remove that filter, apply the next one, check what you need and so on...

If you give some more details on what you want then maybe we can help you find a solution.

demtat

That is what I was afraid of.

Thanks, anyway.

themave

I am not sure what you are asking, but if it is you want to filter on not blank

then <>''

works the '' is two apostrophes’, not a single quote mark

couberpu

demtat wrote:

Is there a way to "OR" filters in NAV? I need a filter to test that one of two fields has been entered (is not blank).

Where you need the filter?
Do you need to check 1. If A = '' then B <> '', 2. If A <> '' then B = '', or 3. A <> '' OR B <> ''?
If you can check it with excel output, then use the IF in excel or you can create a boolean variable in form design to hold the result.

Couber