# Level1 exam formulas error (activity5)

Options
edited January 2023

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.

Tagged:

## Best Answer

• Answer ✓
Options

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!

## Answers

• Options

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

• Options

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

• Options

I solved this issue! Thank you very much!

• Options

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

• Options

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

• Options

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:

• Options

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.

• Options

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

• Options

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?

• Options

What do I do if my roles section is blank?

• Options

Hi,

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

• Options

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

• Options

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

• edited May 2023
Options

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

• Options

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.

• Options

Anyone help here?