I have a table that shows hours saved per group per process. While I am using Totals function as 'Auto' it's generating wrong totals, but selecting Totals Function as 'Sum' giving the right results. I want to show the total/sum in a seperate KPI. However, when I write the formula it shows the total wrong (it shows the same number as when I choose 'Auto' in the table). How can I change my formula to show the same number as when I choose 'Sum' in the table? As far as I can see I cannot choose between Auto and Sum for the KPI.
Additional info is that the 'Completed Cases' is a variable. It consist of incoming cases minus exception cases.
The formula I use for calculating total hours
=sum(aggr($(vCompletedCases),Process,Group))*sum(aggr([Minutes per case per process], Process,Group))/60