Multiplication and adding two different line items

Options
HarishBabu
HarishBabu Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

HarishBabu_0-1650882501227.png

Class 1 is starting from 7 mar and class 2 is from 21 mar
Now i need to write formula in Total 
For example in  21 mar Column, 62 * 2 (which is week 3 * prod )  and 80 * 2 (which is Actual Start - Day 1 * Prod  (Next Wave))
(62*2)+(80*2) = 284 ----- the formula in Total is not correct now

 

I try averaging the Prod and Prod Next Wave but the values can be like 8,3 so averaging not giving accurate calculations

Tagged:

Comments

  • HarishBabu
    HarishBabu Member, ALL USERS Posts: 5 Occasional Contributor
    the Formula of Total is
    ('Actual Start - Day 1' + 'Week 2' + 'Week 3' + 'Week 4' + 'Week 5' + 'Week 6' + 'Week 7' + 'Week 8') *Prod* + ('Actual Start - Day 1' + 'Week 2' + 'Week 3' + 'Week 4' + 'Week 5' + 'Week 6' + 'Week 7' + 'Week 8') * Prod - Next Wave'
    it added 80 and 62 before multiplication

Categories