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

Regards,

Koushik.

• ###### 1. Re: Logic for calculating quantity from actuals

Hi Koushik,

Let me know if the attached,version 10.5 is what you are looking for. If it is and you need me to explain anything let me know.

Regards,

Gerardo

• ###### 2. Re: Logic for calculating quantity from actuals

Hello gerardo, could you please send me the workbook in version 10.4

Regards,

Koushik

• ###### 3. Re: Logic for calculating quantity from actuals

Here it is in version 10.4.

Regards,

Gerardo

1 of 1 people found this helpful