This content has been marked as final. Show 6 replies
I am creating a document where I look at the cover of stock in the warehouse. I want to created a figure based on the stock we currently have, plus the stock on the way, divided by the week before sales.
What I am trying to say is If On Order = 0 then Free Stock/Sum, otherwise ([On Order]+Free_stock)/Sum (if (InWeek (SI_Date, Today(), -1), [Quantity])) .
Any help is much appreciated.