Forum Discussion
Don't sum an Inventory value
Hi, I have a situation with a matrix, where I am comparing plan vs Actual Inventory by month for 4 categaries. But when I select a whole year, the inventory values of all months get summed up...
Hi Ashish_Mathur ,
Thanks for the solution. Just one modification needed.
My 'Plan Inv' shows inventory of December 2022, while my 'Actual Inv' shows inventory of the current month when no date filter is selected.
Is there a way 'Plan Inv' can show data of the month of 'Actual Inv' when no filter is selected?
You are welcome. Why not maintain the discipline of always select a year or year and month?
Yes, since date is floating value (i.e., Every Month new data), I would like to have one new month data appearing on the table.
Your reply does not address my previous question. Just avoid the complication by ensuring that you always select a Year or a Year and month.