Hi All,
I am trying to create a report that will help us classify dead inventory. I am trying to build a formula that will show each item that has not been sold since a certain date, in this case, anything that has not been sold in over 180 days. I only want the item to show if we currently have a quantity on hand of greater than 0.
So far, this is the formula I have attempted:
=NL("Rows","Item",,"Sales (Qty.)","=0","Date Filter",NP("DateFilter",,$E$7),"Quantity on Hand",">0")
In E7, I have =TODAY()-180
The report is still pulling items that have been sold in the last 180 days. How can I correct this?
Any help would be greatly appreciated! Thank you.
Date
Votes
1 comment
-
Jet Reports Historic Posts I was able to get a formula to work. It was:
=NL("Rows","Item",,"Sales (Qty.)","=0","Date Filter",NP("DateFilter",$E$7,$F$7),"Quantity on Hand",">0")
Now I just need to get the items to sort based off of the last sold date :)
F7 just has =TODAY()
Please sign in to leave a comment.