I am using the sum function to find the number of items in the sales line table prior to a specific date. I"m wanting to use a formula that would move with the current date.
=NP("Datefilter",,DATE(YEAR($C$2),MONTH($C$2),0))
(this is used to pull all dates up to the last day of last month. It returns ..9/30/10
I'm using the formula below to pull the sum of the quantity of an item with the Requested Delivery Date referencing the formula above.
=NL("sum","Sales Line","Quantity","No.",$E12,"Document Type","Order","Type","Item","Requested Delivery Date",J$10)
Jet or Excel is not recognizing the ..9/30/10
What is the proper way to pull this type of date range?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi barbarar,
I tried your formulas and they work fine for me. When you say Jet or Excel is not recognizing your filter, do you mean you are getting a #VALUE? What happens when you do Jet -> Debug on that cell?
Regards,
Hughes -
Jet Reports Historic Posts Quick question would be do you need to hard code the cell $J$10 ? Like Hughes says the formulas look right
Please sign in to leave a comment.