level 1 Exam activity 4

ShreyaR
edited November 2022 in Academy Discussions

Hi,
I have been stuck on this question from past few days can anyone please assist me asap Have tried my best but couldn't correctly complete it.
The formula I am using  for Bonus in EMP002 is IF Employed? THEN salary* 'EMP03 Employee Drivers by Role'.Bonus%[LOOKUP:'SYS08 Employee Details'.Role] ELSE 0. is this correct?

 

also not able to get the correct formula for  Car Costs, Medical Costs and Phone cost, mistake in this is leading to wrong answers which are further dependent on this. Please help me out with the exact formulas  and what line items need to be changed in the EMP002 or any other module all confused.

Comments