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

[kshipley]

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.

[Misbah]

@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]

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]

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]

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]

Also I get this error:

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

[Misbah]

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

[kshipley]

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]

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]

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