COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Sofie on 07 Nov 2019 04:28:03 AM

Title: Total per item
Post by: Sofie on 07 Nov 2019 04:28:03 AM
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.
Title: Re: Total per item
Post by: Andrei I on 07 Nov 2019 04:56:28 AM
Did you try

Total( [value] for [cost centre])

Title: Re: Total per item
Post by: Sofie on 07 Nov 2019 05:25:46 AM
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
Title: Re: Total per item
Post by: Andrei I on 07 Nov 2019 07:43:29 AM
What about

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