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.
REP04 Employee Expenses Summary is the aggregated sum for Region and Role. Use SUM in your formula in place of LOOKUP.
It works, thank you!0
can you plzz share the correct formula0
calculate result is wrong for me. what can be the result?0