201 Intermediate Model Building Section 8 actvity #10 Numbers don't match

Options
Evalinde
Evalinde Member, ALL USERS Posts: 3 Occasional Contributor
in Planning & Modeling

I'm working on Section 8 of IMB and the numbers in the sub-region Goal set don't match for US South and US Central. The totals in the bottom row do match with the guide and instruction video, but these specific sub-regions don't. PY Sales and Sub-region % are correct, but the Projected Goal is not. All other sub-regions seems to be correct. 

 

I have included screenshots from my module, the formulas I used and the instruction video to show the difference

Tagged:

Comments

  • Evalinde
    Evalinde Member, ALL USERS Posts: 3 Occasional Contributor

    Hi Paul, I think that is what I did. The formula I used for the Projected Goal in the Sub-regio Goal Set module is      'Sub-region Percent' * Region Goal Set.Projected Goal[LOOKUP: Parent]

     

    I find it very confusion also that it is only for these two sub-regions that I have issues and the other ones are correct. Or maybe that's a coincidence? 

  • Evalinde
    Evalinde Member, ALL USERS Posts: 3 Occasional Contributor

    Solved the problem! I used the Projected Goal iso the Final Goal. Fixed it. 

Categories