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.