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.
You are almost there. However, look at the dimensions of the drivers module. How many are there? If there are multiple dimensions in the source that are not present in the target then you need multiple mappings to match the data and bridge the dimensions gap.
Also, bonus is the only driver which is a % of salary. The others can be referenced directly.