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

Highlighted
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.

 

13 REPLIES 13
Highlighted
Master Anaplanner/Community Boss

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

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

Highlighted
Super Contributor

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

Highlighted
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.
Highlighted
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

Highlighted
Master Anaplanner/Community Boss

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

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

Highlighted
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

Highlighted
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

 

Highlighted
Certified Master Anaplanner

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

Specifically, there are couple things I'd point out to you about the formula you used:

 

  1. After the comma, it appears you typed in "SYS08 Employee Details'.Role" in an attempt to also have the LOOKUP statement apply to it. You have to actually repeat the LOOKUP for each item you want to lookup.
  2. Second, it kind of looks like you typed in the module name since the single-quote at the beginning was left off. Names of modules/line items/etc... will require single quotes around them if they contain special characters or numbers. As a general rule, I will usually always include quotes if I am typing in a module name manually. If I use the "point and click" functionality, Anaplan will apply single-quotes when needed automatically so you don't have to worry about it. 

In either case above, you should get a syntax error when trying to submit the formula. Make sure you look (and share, if you need to ask for assistance) at what the error message says as it can help narrow down what the issue is.