Level 1 Activity 6

lcapon
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
JaredDolich
Moderator

Re: Level 1 Activity 6

@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

 

 


Jared Dolich

View solution in original post

1 REPLY 1
JaredDolich
Moderator

Re: Level 1 Activity 6

@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

 

 


Jared Dolich

View solution in original post