New Contributor

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

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?

6 REPLIES 6
New Contributor

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

Added blueprint screen shot

Community Boss

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

@EDWARD 

 

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

Certified Master Anaplanner

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

Hi Edwards,

 

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

 

Region - Geos L1

Role - Roles

Photo1.png.jpg

 

 

~Vignesh

New Contributor

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

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. 

 

Certified Master Anaplanner

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

Hi Edward,

 

Your Role line Item "Applies to" should be Reps L4, not Roles.

 

Change applies to Reps L4 as shown below.Photo1.png.jpg

 

Role Line item is getting the role of each rep, so it should be calculated at rep l4 level.

 

 

~Vignesh

New Contributor

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

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

 

Best regards,

Ed