## Level 1 Activity 6

Frequent Contributor

## Level 1 Activity 6

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

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

Jared Dolich
2 REPLIES 2
Moderator

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

Jared Dolich
Occasional Contributor

Hi Jared,

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