Anything wrong with my formulas?

YuyaoWang

Hi,

 

I was taking the level1 certification exam, creating REP04 Employee Expense Summary.

Here are my formulas: 

 

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

 

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

 

Car Cost: 'EMP02 Employee Expenses'.Car Costs[SUM: 'SYS08 Employee Details'.Role, SUM: 'SYS08 Employee Details'.Region]

 

Phone Cost: 'EMP02 Employee Expenses'.Phone Costs[SUM: 'SYS08 Employee Details'.Role, SUM: 'SYS08 Employee Details'.Region]

 

Medical Cost: 'EMP02 Employee Expenses'.Medical Costs[SUM: 'SYS08 Employee Details'.Role, SUM: 'SYS08 Employee Details'.Region]

 

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

 

I got incorrect results using these formulas, but I can't find the reason...

 

Thank you.