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
Solved! Go to Solution.