Level 1 Model Building Exam - Model Building Activity 6

Options
NoahBG
NoahBG Member, ALL USERS Posts: 2 New Contributor
in Anaplan Community

Hello all,

I have been trying to work through Model Building Activity level 6 and cannot seem to understand why my lookup formula is off. I am trying to add a formula to REP04 that shows Total Salary expenses by Region and Role. The formula I am using is 'EMP02 Employee Expenses'.Salary[Lookup: 'SYS08 Employee Details'.Region, Lookup:'SYS08 Employee Details'.Role] but it receives an error. 

 

How I understand it is that 'REP04 Employee Expense Summary'.Salary is my target and 'EMP02 Employee Espenses'.Salary' is my source module. Because EMP02 does not contain Region and Role I need a mapping module/s to achieve my goal. I am trying to use 'SYS08 Employee Details'.Region and 'SYS08 Employee Details'.Role for mapping but receive an error. What am I missing? Do I need to be using a different module? If more details are needed please let me know. Thanks for any help!

 

Error message: Format of mapping used for lookup doesn't match any dimension of the source

 

Helpful reference post I believe is relevant: https://community.anaplan.com/t5/Academy-Training/Altering-Line-Item-Formula-with-lookup/m-p/88856#M2524

 

Screenshots:

NoahBG_0-1626889409586.png

 

NoahBG_1-1626889438245.png

 

NoahBG_2-1626889453860.png

 

 

Tagged:

Comments

  • NoahBG
    NoahBG Member, ALL USERS Posts: 2 New Contributor

    @JaredDolich 

    Thank you so much! I tried using SUM twice but must have had some kind of typo. It is working now. I appreciate the help and encouragement! 

     

    For those referencing the post in the future. My end working formula is below:

     

    'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]

  • Bin.Zhou
    Bin.Zhou Member, ALL USERS Posts: 1 New Contributor
    have you got answer for the formula to sum up Bonus? I run into the same issue as you have.
  • kunle
    kunle Member, ALL USERS Posts: 5 Contributor

    I am struggling with Activity 6 despite following some of the suggestions on the thread. Please can someone suggest a hint as to a way out.

    Here is the error i am seeing when i create my formula:

    Error.PNG

     

    Below is the Blueprint view on my REP04, EMP02 and SYS08

    REP04 Blueprint view.PNG

     

    EMP02 Blueprint view.PNG

     

    SYS08 Blueprint view.PNG

     

    Thank you.

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

    Role item probably not listed correctly 

    To solve this problem 

    1. Go to SUM: SYS08 Employee Details

    2. Look at the format of "Role "

    3.Make the changes as below 

    Format-Role

    Type: List

    List: Role

     

    Good luck to whoever may need this explanation!

  • nileshs
    nileshs Member, ALL USERS, Partner Posts: 3 New Contributor

    Hi,

    When I use my SUM formula I am getting blank values.

     

    Also I do not see any data in sys08.region and sys08.role. its blank. how to get the data here. I have formatted them as list G1 region and E3 role.

     

     

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

    One of your main issues on this is that the range of the sum has a value in SYS008 that is not a list or a date. I would make sure that you are ordering your line items properly or properly referencing the correct format for any information in that range in blueprint view!

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

    Hi

    @NoahBG tried using your SUM Logic but the answers are incorrect, the formula is getting validated but both answers got wrong

  • RavinderB
    RavinderB Member, ALL USERS, GroupMember, Employee, Certified Model Builder Posts: 5 Regular Contributor

    @nileshs 

    The formlas requires the SUM function and not LOOKUP. Please explore Anapedia about the techical details around the SUM function.

    I would also explore the line items in the SYS08 module to check the formatting of the items you are summing:

    Screenshot 2022-09-08 at 09.29.19.png

     

    If required check the general lists assoicated with these line items. Does you role list have a top level of All Roles?

    Screenshot 2022-09-08 at 09.30.36.png

     

    Is your EMP02 module updated correctly to reference data in the EMP03 module: e.g.

    Screenshot 2022-09-08 at 09.32.44.png

     

     Try working backwards from you issue to see if the dependecies are correct. If not you will have to amend them. This will then work.

     

    Thank you

     

    Ravinder.




Categories