L1 Model Building Exam Activity 5 - Need Help!

I have been stuck on this problem for the past day now and have been unable to figure out where I am going wrong 😭 It says:

In the EMP02 Employee Expenses module, update the formulas for Bonus, Car Costs, Phone Costs, Medical costs. Update the formulas to reference the driver data in the Drivers by Role module. The employees' costs will be driven by their job role and not department.

This is the error message I keep getting:

Stuck 2.png

Does anyone have any advice as to what I'm doing wrong?

Accepted answers

All comments

TimothyThomas

Hi @tspoon ,

From your screenshot, it appears you're missing the line item in your 2nd LOOKUP formula. It is just saying LOOKUP:*module* rather than LOOKUP:*module*.*line item*. I imagine once you get the line item spelled out in there the formula will work just fine.

Thanks,

Timmy

tspoon

Thanks. I tried fixing the formula to IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'EMP03 Employee Drivers by Role'.Bonus %] ELSE 0 and I am still getting an error message. I don't understand what this means at all:

Stuck 3.png

Here is EMP03:

Stuck 4.png

tspoon

I also tried the formula:

IF Employed? THEN 'EMP03 Employee Drivers by Role’.Bonus % [LOOKUP: 'EMP03 Employee Drivers by Role’.Department, LOOKUP: 'EMP03 Employee Drivers by Role’.Bonus %'.Role] ELSE 0

And am also getting a message saying this is invalid

TimothyThomas

Hi @tspoon ,

I think your 2nd formula (with lookups for Department and Role) is closer. Try replacing the Role lookup with Country instead and see if that works.

Thanks,

Timmy

John4011

@tspoon wrote:
I have been stuck on this problem for the past day now and have been unable to figure out where I am going wrong 😭 It says:

In the EMP02 Employee Expenses module, update the formulas for Bonus, Car Costs, Phone Costs, Medical costs. Update the formulas to reference the driver data in the Drivers by Role module. The employees' costs will be driven by their job role and not department.

This is the error message I keep getting: prepaidcardstatus.com

Does anyone have any advice as to what I'm doing wrong?

use filter and is instance like this

>>> test = [1,2,3,4,5,6,"A","B"] >>> sum(filter(lambda x:isinstance(x,int),test)) 21 >>>

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…