Hi,
While adding formulas to the line items in EMP02 Employee Expenses we were asked to enter the below mentioned formula
Bonus | IF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0 |
but it's throwing an error "Dimension of mapping used for lookup doesn't match any dimension of the result."
Please suggest to resolve this issue.
It is a clear mapping issue. I don't think you should multiply it with the Bonus % of Emp 01 Module instead bring it from Emp 03 Module. You can verify that by checking your dimensions of the the two modules. Your formula should be like
IF Employed? Then Salary * 'EMP 03 Employee Drivers by Role'.Bonus%[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
Hope that helps
Misbah
My bad. I think I jumped the gun. You will have to go step by step
Dimensions of Emp 01 module - Country and Department .
Dimensions of Emp 02 module - Only Employee (It is a Child of Department, Use lookup to bring values from Department to Employees You also have Country as a property of Employee(Another lookup)
Dimensions of Emp 03 module - Department and Role (you might have to build it later probably)
Your formula should be
IF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0
Make sure you refer the line items while building the formula and avoid writing the names of line items manually.
Hope that helps
Misbah
Hi @rahulharjai
I believe there is a mistake in the instructions.
I training someone recently with this same issue.
The formula should be the following:
IF Employed? THEN Salary * 'EMP03 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
The country look up does not apply here.
I hope this helps,
Usman
Hi Usman,
I got confused reading the conversation about the tips to solve the Level 1 certification.
When updating the formulas of EMP02 (Bonus & costs of car, phone and medical), the following message pops up :
Invalid formula for 'EMP02 Employee Expenses'.Bonus: Automatic sum of 'EMP03 Employee Drivers by Role'.Bonus % over Role hierarchy is not possible as Role does not have a built-in top level |
I had typed the same formula, but got this error message:
Invalid formula for 'EMP02 Employee Expenses'.Bonus: Automatic sum of 'EMP03 Employee Drivers by Role'.Bonus % over E3 Role hierarchy is not possible as E3 Role does not have a built-in top level
Any advice?
Thank you!
This is because E3 role doesn't have Top level mentioned in the hierarchy.
Step 1. Go to E3 Role list in Configure tab the "Top level item" is not present. Update as All roles.
Step 2: Still giving error then, delete the "All roles" from Grid view and then again do the Step 1.
Hope this will resolve the issue.