Level 1 Activity 6

lcapon
lcapon
in Modeling

How close am i here???

 

The formula for 'REP04 Employee Expense Summary'.Salary is invalid:

Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0

Tagged:

Best Answer

  • JaredDolich
    JaredDolich
    Answer ✓

    @lcapon 

    Try using the SUM formula. You've already checked if the employee is employed? so you don't need to do that again.

     

    Correct Formula

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

    Yours

    Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0

     

     

Answers

  • julioarrastia
    julioarrastia

    Hi Jared,

     

    I used the formula but it still doesn't work and I'm not sure why. Hoping you can help.

     

    julioarrastia_0-1641804317411.png

     

  • Samuelafo
    Samuelafo

    Hi @julioarrastia, better late than never, click the blueprint view to edit the REP04 Employee Expense Summary module, the timescale of the line items should be set to Year not Month

Categories