Is ther a way to "OR" filters?

demtat
demtat Member Posts: 5
edited 2010-05-04 in NAV/Navision Classic Client
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).

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    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
    demtat Member Posts: 5
    That is what I was afraid of.

    Thanks, anyway.
  • themave
    themave Member Posts: 1,058
    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
    couberpu Member Posts: 317
    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

Categories