## REP04 Employee Expense Summary Formulas New Contributor

## REP04 Employee Expense Summary Formulas

I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and results below and would like guidance in developing the appropriate calculation formula.

First Attempt (1A): Created a basic formula importing data from the EMP02 Employee Expenses module, but each region has the same expenses between each other.

Second Attempt (2A): Added to the formula including region and department, but calculation is invalid. I have tried referring to different modules and receive errors as well.

1 ACCEPTED SOLUTION

Accepted Solutions  Contributor

## Re: REP04 Employee Expense Summary Formulas

REP04 Employee Expenses Summary is the aggregated sum for Region and Role. Use SUM in your formula in place of LOOKUP.

Regards,

Srikanth

3 REPLIES 3  Contributor

## Re: REP04 Employee Expense Summary Formulas

REP04 Employee Expenses Summary is the aggregated sum for Region and Role. Use SUM in your formula in place of LOOKUP.

Regards,

Srikanth New Contributor

## Re: REP04 Employee Expense Summary Formulas

It works, thank you! New Contributor

## Re: REP04 Employee Expense Summary Formulas

can you plzz share the correct formula