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

    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.