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

Options
EDWARD
EDWARD Member, ALL USERS Posts: 4 New Contributor
in Planning & Modeling

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?

Tagged:

Comments

  • EDWARD
    EDWARD Member, ALL USERS Posts: 4 New Contributor

    Added blueprint screen shot

  • EDWARD
    EDWARD Member, ALL USERS Posts: 4 New Contributor

    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
    EDWARD Member, ALL USERS Posts: 4 New Contributor

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

     

    Best regards,

    Ed

Categories