Values are not matching as per 9.2.6

SuhasDesai
SuhasDesai
in Modeling

Hello Team, 

While working on Model Building course 1, i am stuck at Activity 9.2.6. The issue is, upto 9.2.5, every output is matching. But for 9.2.6, after making the changes, the final output is not matching.

 

SuhasDesai_0-1626439579987.pngSuhasDesai_1-1626439621652.png

 

Tagged:

Answers

  • TimWard70
    TimWard70

    TimWard70_0-1626440137128.png

    Don't think FY19 is a forecast year so your formula is returning zero.  Does it work for 2021?

  • SuhasDesai
    SuhasDesai

    Appreciate your quick response, Tim. 😄

     

    Please note, i tried entering time for 2021, but same result. The values are not getting updated.

     

    Additionally, i tried to check on Level 1 Model Building sample which is provided at the start of the course. I changed the FY2021 Unit Price% to 5%, and checked the values in REV03 Unit Price Growth %. They are unchanged as well.

    SuhasDesai_0-1626440676347.png

     

    SuhasDesai_2-1626440705339.png

    Thank you.

  • TimWard70
    TimWard70

    The price assumptions are at the product family level and you are pulling them into a product level module - try using a mapping table from product to product family and the lookup function, this may mean you also have to lookup the year rather than using year value...

Categories