Level 1 Model Building certification exam: help on formulas in Employee Expenses

kshipley
New Contributor

Level 1 Model Building certification exam: help on formulas in Employee Expenses

For some reason I can't figure out the formula set up for questions 3 & 4 bonus and phone costs by role.  I am wondering if my references are mismatched.  Any help on this is appreciated as I feel like I am struggling by myself here and can't ask anyone or anything to help me out.

 

15 REPLIES 15
Misbah
Moderator

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

@kshipley 

 

Can you please share the related modules & line items for which you are getting your answers wrong. Will try to see what issues are there in the formula. Don't paste your questions here please

 

Thanks,

Misbah

kshipley
New Contributor

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

matching roles in the Employee Drivers by Role module to the SYS08 Employee details module in order to pull over the medical costs by role is my issue.

 

My formula: 'Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, SYS08 Employee Details'.Role]

Kanishq17
Community Boss

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

HI, I guess there is an issue with the module name you are typing as the source module,

 

'EMP03 Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] this is the formula i used and its working fine

 

Maybe you are missing complete module name

kshipley
New Contributor

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

That's exactly what I have been doing and it says level mismatch. But my formula also has an if/then statement built into it for some reason.
kshipley
New Contributor

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

Also I get this error:

 

Data type mismatch: format other than LIST or DATE being referenced as a relation

Misbah
Moderator

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

@kshipley Your module name in the formula seems to be wrong.

kshipley
New Contributor

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

this is the explanation I am getting on my formula

 

Data type mismatch: format other than LIST or DATE being referenced as a relation

bdeaton
Certified Master Anaplanner

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

What are your applies to and formatting settings for each of the following?

  • Source line item
  • Target line item
  • Two mapping line items used

 

Naaz09
New Contributor

Re: Level 1 Model Building certification exam: help on formulas in Employee Expenses

It’s format related error I believe from error description.