Figures and formulas look fine in my Rep Quota Module (Attached is the screen shot),
But in Sub-Region Quota module my data seems to be different than that in the learning video,
I have attached screen shots from both modules for reference.
What are your values for 'Over-Assign'.'Sub-region' and 'Sub-region Goal Set'.Final Goal ?
Any override values set?
Thanks Mark for your reply,
'Over-Assign'.'Sub-region' is set to 5% and 'Sub-region Goal Set'.Final Goal I have attached the Screen shot,
There are couple of Override values which you should be able to find in attached file.
For 'Sub-regions L3'.Northeast, VERSIONS.Forecast, TIME.'Jan 15' I have the value 793959.5246223527
drilling down on that to Allocation, I see:
Trying to work backwards to see where numbers differ...
You could share the model with me, might be able to find it easier.
I wouldn't worry too much about hitting the exact numbers though, much better to work through and understand why the numbers you have are there. Use the drilldown to dig back through formulas to see where the valuse are from, eventually get back to the raw numbers and it should all make sense...
Thank You Mark for the response,
Its only for Northeast region that my values are mismatched, let me drill down and try finding it myself, Else i'll share my model with you.