Nprinting Advanced Search

[ali_hijazi]

Hello 
I have an Nprinting Report and I want to create a filter 
the filter should be defined on a field named BU
I want that BU is any value except  BU1 and BU2
kindly advise on how the syntax is under the Advanced search

[Lech_Miszkiewicz · Accepted solution]

=Count(Distinct {<Disease=-{'BU1','BU2'}>} BU)>0

optional you can use "1" to ignore any other filters you apply in that report: 

=Count(Distinct {1<Disease=-{'BU1','BU2'}>} BU)>0

cheers

[Lech_Miszkiewicz]

just to clarify - there can be many other ways of writing this advanced search expression - i just use count(distinct.... syntax as I like to be able to use set analysis in it.

cheers

[PrashantSangle]

Create new field in dashboard which exclude those field values. & use that in your report.

Regards,

Prashant Sangle

[Lech_Miszkiewicz]

HI @PrashantSangle 

That is not advanced search tip though - This is a valid solution but not appropriate to the question I will argue. Your solution does not require advanced search as you can simply create a flag in load script and use "Value is:" filter. 

So bottom line is: for advanced search option use my option or other advanced search expression you like to come up with or if you can access data model and add that new field use value is filter with flag....