0

Filtering using two records in one table

Jet Reports Historic Posts

June 30, 2010 14:27

None

Follow

Hi, can someone help me with the following.

I am trying to count the number of sales lines within a specific date range (shipment date) where the preferred shipment date is smaller than the realized shipment date. I have no clue how to realize this. The workaround I am using is to list all shipments (rows; sales line) and than use excel to count the number of sales line where the prefered shipment date is smaller than the realized shipment date. Obviously this is not convenient because if I want multiple periods I need multiple worksheets.

Any help is appreciated.

Thanks,
Andor

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts July 16, 2010 16:28 Official comment

  Hi Andor,
  
  I think you need a calculated filter for this. Try a formula like this:
  
  =NL("Count","Sales Line",,"Shipment Date",$C$5,"Preferred Shipment Date","=""<""&NF(,""Realized Shipment Date"")")
  Does that work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts July 21, 2010 11:58

  Hughes,
  
  Sorry for the late response but you are absolutely brilliant! It works perfectly. Thanks very much for the help!
  
  Regards,
  Andor