Level 1 Activity 6

lcapon

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

JaredDolich

@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

 

 

julioarrastia

Hi Jared,

 

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

 

 

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