I have been working on the test activities 4 and 5, I have built List: Role and imported data, I have built Employee Drivers by Role and imported data, Added lines to SYS08 for Bonus, Car, Phone, Medical and Role. I can't seem to get the Role to populate. Department is a list of E1, and Role is a list of Role.
Have been workign on this for too long trying different solutions. Where is the issue I can't see.
I have been using the formulas:
IF Employed? THEN Salary * ‘Emp03 Employee Drivers by Role’.Bonus%[LOOKUP: ‘SYS08 Employee Details’.Department, LOOKUP: ‘SYS08 Employee Details’.Role] Else 0
Thanks,
MPW