0

HELP FILTER UNIQUE

Jet Reports Historic Posts

January 12, 2017 15:23

None

Follow

Good morning,

i have this function

=NL("Rows","Item",,"Department Code","unipro")

how can i filter this, so it just give me the items, that HAVE sales >0?

thank you

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 12, 2017 16:36

  Hello -
  
  Let's assume we define sales like so:
  
  
  
  The easiest method would be to use Conditional Hiding to hide the zero values:
  
  
  If you need to not even return the zeros, the technique is similar to the sort-by-sum method described here –> http://community.jetreports.com/viewtopic.php?f=23&t=2109&sid=2040344927f4606ee0680cabc29db7e4
  
  You could try this function:
  =NL("Rows","Item","No.","=NL(""Sum"",""Item Ledger Entry"",""Sales Amount (Actual)"",""Item No."",NF(,""No.""))",">0")