I've entered this formula for the goal calculation.
IF Active? THEN ROLE GOALS.Quota Goal[LOOKUP: Region, LOOKUP: Role] / 12 ELSE 0
I'm getting this error.
Dimension of mapping used for lookup doesn't match any dimension of the result
Has anyone else run into this?
Go to Solution.
Added blueprint screen shot
Can you please add the blueprint of the target module, Req Quota Module?
Can you check your Region, Role line items are formatted correctly as shown below.
Region - Geos L1
Role - Roles
See the attached. Mine looks almost the same, except for the Role line item.
I have an icon next to the Role. When I click on it, it takes me to the roles.
Your Role line Item "Applies to" should be Reps L4, not Roles.
Change applies to Reps L4 as shown below.
Role Line item is getting the role of each rep, so it should be calculated at rep l4 level.
Thanks for finding that. One more thing for me to check going forward.