0

Identify Item with zero inventory on different days

Jet Reports Historic Posts

April 27, 2017 13:47

None

Follow

Hi all,

i have a challange: I should identify items out of our NAV, that had no inventory on three differen Due Dates.

The Due Dates are 12.31.2014, 12.31.2015 and 12.31.2016.

Is there a Way to have a filter like Inventory on 12.31.2014 + Inventory on 12.31.2015 + Inventory on 12.31.2016 = 0 ?

Please forgive my bad English, because it is not my native language.

Thank you in advance.
Okko

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts April 27, 2017 17:08

  Have you tried filtering the dates this way?
  
  12.31.2014|12.31.2015|12.31.2016
  
  or, if you want to have the dates in separate cells
  
  C3 = 12.31.2014
  C4 = 12.31.2015
  C5 = 21.31.2016
  
  and then use this in your formula: C3 & "|" & C4 & "|" & C5 (I added spaces to make it more readable)