New Contributor

## Level 1 Model Building Exam - Model Building Activity 6

Hello all,

I have been trying to work through Model Building Activity level 6 and cannot seem to understand why my lookup formula is off. I am trying to add a formula to REP04 that shows Total Salary expenses by Region and Role. The formula I am using is 'EMP02 Employee Expenses'.Salary[Lookup: 'SYS08 Employee Details'.Region, Lookup:'SYS08 Employee Details'.Role] but it receives an error.

How I understand it is that 'REP04 Employee Expense Summary'.Salary is my target and 'EMP02 Employee Espenses'.Salary' is my source module. Because EMP02 does not contain Region and Role I need a mapping module/s to achieve my goal. I am trying to use 'SYS08 Employee Details'.Region and 'SYS08 Employee Details'.Role for mapping but receive an error. What am I missing? Do I need to be using a different module? If more details are needed please let me know. Thanks for any help!

Error message: Format of mapping used for lookup doesn't match any dimension of the source

Screenshots:

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Level 1 Model Building Exam - Model Building Activity 6

Oh, so, so close. You used LOOKUP. Try using SUM instead. Your logic is flawless. Just the wrong function. You got this!

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

Jared Dolich
2 REPLIES 2
Moderator

## Re: Level 1 Model Building Exam - Model Building Activity 6

Oh, so, so close. You used LOOKUP. Try using SUM instead. Your logic is flawless. Just the wrong function. You got this!

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

Jared Dolich
New Contributor

## Re: Level 1 Model Building Exam - Model Building Activity 6

Thank you so much! I tried using SUM twice but must have had some kind of typo. It is working now. I appreciate the help and encouragement!

For those referencing the post in the future. My end working formula is below:

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