Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.
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.