L1 MB Certification Test: EMP02 Employee Expenses

Kevinc107
New Contributor

L1 MB Certification Test: EMP02 Employee Expenses

Hi- I'm trying to update the formulas to reference the drivers in EMP03 Employee Drivers by role. I keep getting an error when i try to update the formula. Do you know why this error is happening?

1 ACCEPTED SOLUTION

Accepted Solutions
Kanishq17
Community Boss

Re: L1 MB Certification Test: EMP02 Employee Expenses

Hi @Kevinc107 

Your source module is dimensioned by department and role and target is dimensioned by employee , so in order to refer value , you need to esatblish mapping between all source and target dimensions , so in the lookup formula, you must use department and role mappings of the sys 08 module ans make sure they are list formatted to the department and role dimensions

 

 

View solution in original post

3 REPLIES 3
abhi1017
Super Contributor

Re: L1 MB Certification Test: EMP02 Employee Expenses

Hi Kevin,

 

If the formula has to work then it should consider getting source and target module at same dimensions.

In the formula written the source module dimension doesn't match with the target.

 

Recheck your formula.

Check whether the source module being referenced is right.

 

~Abhi 

Kanishq17
Community Boss

Re: L1 MB Certification Test: EMP02 Employee Expenses

Hi @Kevinc107 

Your source module is dimensioned by department and role and target is dimensioned by employee , so in order to refer value , you need to esatblish mapping between all source and target dimensions , so in the lookup formula, you must use department and role mappings of the sys 08 module ans make sure they are list formatted to the department and role dimensions

 

 

View solution in original post

neerajahuja77
New Contributor

Re: L1 MB Certification Test: EMP02 Employee Expenses

Hi Did you find the solution of this issue. I am also facing the same issue with Formula. Can you please share