nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Level 1 Activity 6

lcapon

How close am i here???

The formula for 'REP04 Employee Expense Summary'.Salary is invalid:

Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0

Accepted answers

JaredDolich

@lcapon

Try using the SUM formula. You've already checked if the employee is employed? so you don't need to do that again.

Correct Formula

Salary = 'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]

Yours

Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0

All comments

JaredDolich

@lcapon

Try using the SUM formula. You've already checked if the employee is employed? so you don't need to do that again.

Correct Formula

Salary = 'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS08 Employee Details'.Role]

Yours

Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0

julioarrastia

Hi Jared,

I used the formula but it still doesn't work and I'm not sure why. Hoping you can help.

Samuelafo

Hi @julioarrastia, better late than never, click the blueprint view to edit the REP04 Employee Expense Summary module, the timescale of the line items should be set to Year not Month

Quick Links

Can you help?

Unanswered questions

HOW TO CONTACT TENANT ADMINSTRATOR FOR REQUESTING ACCESS TO PAGE BUILDER
Hi All, I taking level 2 training for model building and need access for my apps. Could someone direct me how to contact the tenant administrator for requesting access to page builder role. Is there any email ID through which i can do this ? Thank you, Sandeep Reddy
An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…