Level 1 Exam Activity 5

Options
WanchiS
WanchiS Member, ALL USERS, Employee, Certified Model Builder Posts: 5 Occasional Contributor
in Anaplan Community

Hello Anaplan experts,

 

I am having issue with the activity 5.  I tried using this formula:

 

IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

 

However, I got an error message:  "Invalid formula for 'EMP02 Employee Expenses'.Medical Costs: Automatic sum of 'EMP03 Employee Drivers by Role'.Medical Benefit over Role hierarchy is not possible as Role does not have a built-in top level"

 

What does this mean and what can I do to fix it?

 

Thank you!

 
 
Tagged:

Comments

  • WanchiS
    WanchiS Member, ALL USERS, Employee, Certified Model Builder Posts: 5 Occasional Contributor

    Thanks so much for your help!  I added the top level to the "Role" list, and tried updating the formula again, but got another error message, saying "Data type mismatch: format other than LIST or DATE being referenced as a relation".  I have a disconnect here because:

    1) it does not make sense that a "Role" list to have "list" or "date" as the format, so I'm not sure why the error message is referring to them?

     

    2) the formula I have constructed does not include the "Role" list in its reference (neither do the Target module (EMP02) or the Source module (EMP02) or the Mapping module (SYS08) referenced in the formula, so I am unsure how adding the top level to the "Role" list would correct the error?

     

    IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

     

    Thank you so much!

     

    WanchiS_0-1604010755728.png

    WanchiS_1-1604010905578.png

    WanchiS_2-1604011150854.png

     

     

     

  • WanchiS
    WanchiS Member, ALL USERS, Employee, Certified Model Builder Posts: 5 Occasional Contributor

    Thanks Einas! Your explanations are very helpful. I believe I have the correct lookup formula, which is very similar to the solution discussed in your 2 other posts:

    IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

    I added the top level to the "Role" list, and tried updating the formula again.

    I now get a different error message, "Data type mismatch: format other than LIST or DATE being referenced as a relation", which I am trying to resolve.  Would you have any tips or advice?  Thank you!

  • JulieBurgess
    JulieBurgess Member, ALL USERS Posts: 1 New Contributor
    @WanchiS wrote:

    Thanks Einas! Your explanations are very helpful. I believe I have the correct lookup formula, which is very similar to the solution discussed in your 2 other posts:

    IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 Official Site

    I added the top level to the "Role" list, and tried updating the formula again. 

    I now get a different error message, "Data type mismatch: format other than LIST or DATE being referenced as a relation", which I am trying to resolve.  Would you have any tips or advice?  Thank you!

    I faced the same issue, still facing that, no solution yet.

Categories