Total per item

[Sofie]

Hi all

In my report, I am using the hourly rate to count the total hours worked per cost center. However, we are moving to a new hourly rate, and per cost center I want to have the total.
So instead of the 2 lines, in the example attached (rate 81,25 and rate 85,00), these needs to be add up.



Do you know how to do this? I have already tried to total them and used also the running-total, but both functions were not the solution.

[Andrei I]

Did you try

Code Select Expand


Total( [value] for [cost centre])


[Sofie]

Hi Andrei

I've tried this, but it gives the total per cost center for all of the projects, where I need the total for the cost per project.

Kind regards
Sofie

[Andrei I]

What about

Code Select Expand


Total( [value] for [cost centre],[project])