REP04 Employee Expense Summary Formulas

vciarami
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
SrikanthKamath07
Contributor

Re: REP04 Employee Expense Summary Formulas

Hi @vciarami 

 

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

 

Regards,

Srikanth

View solution in original post

3 REPLIES 3
SrikanthKamath07
Contributor

Re: REP04 Employee Expense Summary Formulas

Hi @vciarami 

 

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

 

Regards,

Srikanth

View solution in original post

vciarami
New Contributor

Re: REP04 Employee Expense Summary Formulas

It works, thank you!
akankshaschavan
New Contributor

Re: REP04 Employee Expense Summary Formulas

can you plzz share the correct formula