NPrinting Filter >0

[hopkinsc]

Hey guys,

I am struggling to get a filter to work in NP - version Sep 2018.

Its a basic filter, all i want to do is make a selection on a field greater than 0 (zero).

Its a field that holds sales qty, there are negatives in the field (where returns have been processed), so i only want to see the values that are greater than 0

I have tried

Evaluate Value 

>0

=>0

=if(Sales>0,Sales)

Value is

>0

=>0

Can anyone help please?

[Daniel_Jenkins · Accepted solution]

Hi,
NPrinting 17.x/18.x does not (yet) have options to filter based on Variables, Bookmarks and Advanced Search (which is what you are trying to do). Perhaps you could flag the records that have Sales > 0 in the load script and use that flag in your NPrinting filter?

HTH - Daniel.

[hopkinsc]

Thanks Daniel, I have added some set analysis in the chart instead of trying to use NP to do the selection.