#Activity 10 - Sub-Region Goal Set - Projected Goal Formula

Previous Contributor

#Activity 10 - Sub-Region Goal Set - Projected Goal Formula

Hi, To find out the Projected Goal for sub-regions I am using the following formula: 'Sub-region Percent' * Region Goal Set.Projected Goal[LOOKUP: Parent] But the result of this calculation is not matching with that of video session (chapter 8). However, If I use the below formula, it matches:  'Sub-region Percent' * Region Goal Set.Final Goal[LOOKUP: Parent] But I am not clear of the concept why should I use Final Goal of parent when I am calculating projectd Goal. Can Anyone please help me in understanding the logic. Regards Bikash

Message 1 of 2
1 REPLY 1
Highlighted
Super Contributor

RE: #Activity 10 - Sub-Region Goal Set - Projected Goal Formula

Hi Bikash,  The name "Final Goal" in this build is the goal after all overrides and holds have been applied. Since we're planning Top-Down from Region to Sub-region, we're using that Final Goal number to include the Hold/Override calculations.
Message 2 of 2