Level 1 Model Building Certification Exam : Unable to format Roles as List in SYS08

Options
bambrose
bambrose Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

I am having an issue with the Role list. When I try to format the Role line item in SYS08 it gives me this error: Format of mapping used for lookup doesn't match any dimension of the source. I've attached a screenshot of the blueprint. 

 

I've had no luck fixing this issue and I'm going on hour 4 of trying to finish this exam. Hoping someone can help me out of this rabbit hole!

 

Thank you!

Tagged:

Comments

  • bambrose
    bambrose Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor

     Also, I understand what the formulas need to be in EMP02, but I think this format issue in SYS08 is causing the error when I try to update the formulas in EMP02:  Data type mismatch: format other than LIST or DATE being referenced as a relation.

     

    Attachment of screenshots of EMP02 and EMP03 included for reference.

  • ajay2021
    ajay2021 Member, ALL USERS Posts: 1 New Contributor

    Thank you so much just adding if you have pasted the same formula to other line items like a phone bill, Medical cost please remove them as well this will not allow making changes from number to list.

Categories