Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table with one dimension (Center) and measure (Sum (Sales)).
I want to send the reports when there is data (i.e. Sum(Sales)>0) and don't send it when sum(Sales)=0.
I tried condition based on report contains values, but we it is still getting generated as the table has Centers with the value 0.
Can someone pls advise?
Thanks,
Varun
Check if you can control set analysis in N-Printing with
Sum ({<Centre={"=Sum(Sales)>0"}>} Sales)
That is what I am looking for (i.e. Where to use this condition). I know we can write the condition in NPrinting but it doesn't have option to write an expression
you can create chart which will have a measure you need to validate your condition and then use in NPrinitng condition "Chart has values" and on top of that create a filter using Advanced search option where you would filter Centres using the expressions you already know: =Sum(Sales)>0
I have written a post about that here:
https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/