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