Identify Item with zero inventory on different days

Questions and Answers asked by users to users, about how others use Jet Reports.

For additional "how to" information, please visit our online Knowledge Base ... ofessional
Forum rules
The Jet Reports Community forums are not a guaranteed support medium. Official support for Jet Reports is available only through the support desk at Staff responses to posts on the forum are not guaranteed.
Posts: 1
Joined: Thu Apr 27, 2017 6:38 am

Identify Item with zero inventory on different days

Postby okkolehmann » Thu Apr 27, 2017 6:47 am

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.

Posts: 122
Joined: Tue Jul 09, 2013 2:04 pm

Re: Identify Item with zero inventory on different days

Postby Heather » Thu Apr 27, 2017 10:08 am

Have you tried filtering the dates this way?


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)

Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 2 guests