Intermediate Model Building - Req Quota Module - Goal calcuation is not working

EDWARD

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?

VIGNESH.M

Hi Edward,

 

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.

 

 

~Vignesh

EDWARD

Added blueprint screen shot

rob_marshall

@EDWARD 

 

Can you please add the blueprint of the target module, Req Quota Module?

VIGNESH.M

Hi Edwards,

 

Can you check your Region, Role line items are formatted correctly as shown below.

 

Region - Geos L1

Role - Roles

 

 

~Vignesh

EDWARD

Hi -

 

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. 

 

EDWARD

Thanks for finding that.  One more thing for me to check going forward.

 

Best regards,

Ed