6 Replies Latest reply: Dec 5, 2017 1:22 PM by Anand Chouhan RSS

    IF Statement

    David McFall

      Hi,

       

      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.

       

      Regards

       

      David