201 - Intermediate Model Building Q. Region Goal Set override not syncing with Sub-region Goal Set
Hi
I recently completed the 201 model building course (online) and I noticed during the exam that when applying an override of £8M to the Oceana Region (Region Goal Set module) in the 'Geo Goal Setting' Dashboard, the corresponding region was not syncing in the 'Sub Region Goal Set' section of the dashboard. I have been back through the guide and I am struggling to find where I have gone wrong.
Surely if I update Oceana to £8m the Sub Region Goal Set module should reflect this and the sub regions of New Zealand and Australia should adjust accordingly?
Advice on where the sync occurs via formula within modules or within the dashboard itself would be appreciated.
I've attached 2 screen shots.
Regards
Michael
Tagged:
0
Answers
-
I solved it myself 🙂
The projected goal calc in the Sub-Region Goal Set module was incorrect.
I was using:
'Sub-region Percent' * Region Goal Set.Projected Goal[LOOKUP: Parent]
The correct calc is:
'Sub-region Percent' * Region Goal Set.Final Goal[LOOKUP: Parent]
This post helped me:
https://community.anaplan.com/t5/201-Intermediate-Model-Building/Activity-10-Sub-Region-Goal-Set-Projected-Goal-Formula/m-p/4029#M1170