Level1 exam formulas error (activity5)

I tried to update the formulas but it shows Invalid fomula .

Updated formulas for Bonus was below,

IF Employed? THEN Salary * 'EMP 03 Employee Drivers by Role.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0

What exactly am I doing wrong here? Any help would be greatly appreciated.

Accepted answers

MarkWarren

Hi, you're right. I didn't spot it. The single quotes here. (and previously there was only a quote at the start of the module name)
EMP03 Employee Drivers by Role''

What I would do when I can't spot it, I copy one I know is working and modify it!

All comments

MarkWarren

Hi, if you haven't spotted it already the SYS08 lookup should be to Role not Country

Mao0511

Thank you for your advice and I tryed it again but still error.

The formula for 'EMP02 Employee Expenses'.Bonus is invalid:

Bonus = IF Employed? THEN Salary * EMP03 Employee Drivers by Role''.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

MarkWarren

Mao0511

I solved this issue! Thank you very much!

jack.stewart@ralphlauren.com

How did you solve this? Is your list "E3 Role" have a parent hierarchy? I can not assign a parent hierarchy

jack.stewart@ralphlauren.com

I got the formula to not error out but now i am not getting any results as the formula is returning all 0

Any help?

Here is my formula for the Bonus line item

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

JaredDolich

jack.stewart@ralphlauren.com !!

Great work on EMP02. Your formula is perfect. Nice job swapping in department and role. So if you're still getting zeroes then one of two things are missing. Either the mapping in SYS08 is missing or the Bonus % value in EMP03 is missing. Let's take a look.

SYS08 should look like this - make sure department and Role are populated and are LIST formatted. If role is missing, also make sure you've created the Role List and imported the values correctly:

EMP03 should look like this:

jack.stewart@ralphlauren.com

Jared,

Thanks for looking into. I was able to get the formula to populate results. I also finished the test with a 100. On to Anaplan Way.

JaredDolich

jack.stewart@ralphlauren.com You're a rock star! Nice job. Good luck with TAW.

AverySchober

Hi,

I am getting stuck on the same part in section five and I have exactly what you're two screenshots are showing, but I keep getting this error message:

I am not sure what I am doing wrong. I do not want to apply a top level to E3 Role because then it messes up my data.

Could you please assist?

ShawnaM

What do I do if my roles section is blank?

Hi,

My roles are missing.Not sure how to proceed. Please help.

FlynnWil

Where did you get the role information in SYS08? I can't find this anywhere?

MPWall

Did you not download the file from Section 4 of the test, like I failed to do? It is the Employee Details by Role.csv. Then you import it into SYS08, pay attention to what column the roles are in. Good luck

Carlos3k

I did all of this. And I'm still getting only zeroes out of my formulas. I imported the correct file into SYS08 and made sure to map the correct columns

tiffanymac2001

@JaredDolich

I have been trying to figure out where your totals are coming from in EMP03 Employee Drives by Roles

I tried to add a formula however the column is read only

Any help would be appreciated.

bhushanshastrakar

Anyone help here?

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…