EMP02 Employee Expenses Formula is not working

Melissaay

Hi - I have been trying to calculate bonus, car, phone, and medical costs and the function i input gives me an error message. I am not sure what i am doing wrong. Can someone help me please?

 

Formula for Bonus:

IF

Employed?

THEN

Salary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role]

ELSE

0

 

Thank you. 

 

 

Melissaay

Hi @JaredDolich thank you so much! 

I do not have the "Role" format listed - how do I add that one? Thank you so much! Please see attached. 

Melissaay

@JaredDolich thank you so much! have a great one!