0

Need to Filter using OR

I am using NL(ROWS) to list Sales Invoice Lines based on Posting Date and Type filters.

I have 2 numeric fields on the Sales Lines that could =0.  I would like to filter the lines to only show when either field is >0 but not include them when they are both =0.

I have tried OR, Union and Filter but can't get any to work.

Is this possible?

Michael

0 comments

Please sign in to leave a comment.