Discussions
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
On hand Quantities in Run Rate search
Hi All
Me again! Sorry to trouble you once more with my issues. I was wondering if anyone can help. I have a run rate report which denotes how many items we have sold on a monthly basis.
When I try to add in any current totals - On Hand Quantity, Available Quantity, Quantity on Order, it does not work.
Because the fields are grouped, if I do not choose a summary type the column is not there, but if I do choose a summary type such as "Sum" then it displays the data in a strange way, for example I think that Sum adds up the current value of the stock rather than the Quantity. How do I display the Quantities currently in the warehouse and on order in a report such as this. Screenshots below, any help will be greatly appreciated: