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

    Logic for calculating quantity from actuals


      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