Need help using an OR filter in an NL formula

Guardsman Henk

March 30, 2023 13:56

None

Good afternoon,

I'm stuck trying to figure out how to apply an "OR" function on my NL formula. I'm using the Dutch version.

I have the following formula, but as it works all filters function as an "AND" command, what I seek to figure out is how to apply an "OR" between different filters.

=NL("Rijen";"Klant";;"Geblokkeerd";"Verzending|Factuur|Alle";"Geblokkeerd vanwege privacy";"Onwaar")

For the above I'd like to insert an OR function as filter for Geblokkeerd";"Verzending|Factuur|Alle" OR "Geblokkeerd vanwege privacy";"Onwaar" .

How do I modify the NL formula to get the results I seek?

Thank you in advance,

Date Votes

1 comment

0
CascadiaDataworks April 03, 2023 15:54
To do an OR with two different filters, you will need to create two separate NL(Filter) functions and array calculations: https://support.jetglobal.com/hc/en-us/articles/219403037-Array-Calculations
```
=NL("Filter";"Customer";"No.";"Blocked due to privacy";"False")
```
```
=NL("Filter";"Customer";"No.";"Blocked";"Shipping|Invoice|All")
```
```
=NP("Union";REFERENCE TO NL FILTER 1, REFERENCE TO NL FILTER 2)
```
```
=NL("Rows";"Customer";;REFERENCE TO NP UNION)
```
Comment actions Permalink

Please sign in to leave a comment.