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?

Best Answer

  • VIGNESH.M
    Answer ✓

    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

Answers