3 Replies Latest reply on Aug 29, 2018 6:40 AM by Gerardo Varela

    Logic for calculating quantity from actuals

    koushik.neelakantha

      Hello everyone,

       

      I need to apply below logic for getting quantity from actuals. sharing sample workbook with logic from superstore would be helpful.

       

      o 1st month of Quarter:     Quantity= Monthly Actuals * 3
      o 2nd month of Quarter:    Quantity = Average of first two monthly Actuals * 3

      o 3rd month of Quarter:     Quantity = Sum of three monthly Actuals

       

      Regards,

      Koushik.