Level 1 Activity 5 _ Employee expense Lookup Formulas resulting in zeros

Options
CommunityMember87446
CommunityMember87446 Member, ALL USERS Posts: 5 Contributor
in Planning & Modeling

I am getting zeros for my lookup formulas in Activity 5 for employee expenses.

 

EMP03 Employee Drivers by Role seems right.   Attached

 

SYS08 Employee Details seems right _ Roles, Departments.  Attached

 

My lookup reference formula seems right - referencing the EMP03 file and mapping to the associates via Lookup in the Sys08 File 

 

What am I not seeing here?   Can anybody give me a pointer.

 

Also... what happens if you time out in the exam? 

 

 

 

 

 

 

Tagged:

Comments

  • CommunityMember87446
    CommunityMember87446 Member, ALL USERS Posts: 5 Contributor

    Thank you for your response.

     

    I have also narrowed down that I failed to put the "applies to" List dimension up front.

    The problem I am having now is that I cannot add it after the fact.  I keep getting error messages because I went forward with the tasks before the problem became obvious and everything is so intertwined now.

     

    I am thinking the best way to solve the problem is to reset my model to an earlier version.  Then redue being careful not to make the same dimension omission which I did at first which is leading to this problem (I think).

     

    Can you guide me where to reset my Model to the start of Activity 5 tasks?

  • CommunityMember87446
    CommunityMember87446 Member, ALL USERS Posts: 5 Contributor

    Thanks so much.

     

    Looked deeper into the lesson material on LOOKUP vs SUM.

     

    One possible feedback (and maybe I am just forgetting).... I don't recall exercises using both methodologies for the Formula in the lesson.   Given the traffic in the community blog on this specific point, it might be a nice add for the training lessons.  

     

    I got it corrected and passed the exam, but needed to go back into lesson material (during the middle of the exam) to figure out.   One thing for sure... after that I won't forget to reflect on the formula alternatives for fetching data 

     

    Thanks for your question on what to reflect on!  Big help!

Categories