2 Replies Latest reply on Nov 23, 2018 9:16 AM by Oyem Badinga

# Grand Total Calculation Not Correct

Hi Everyone,

I have a vehicles used for the transport goods. Every day allowance for the vehicle is 7000 XAF. As the column is repeating for multiple trip rows.

To get exact allowance per i used average. like avg(allowance).

Now in the grand total i wanted to see the total allowance allocated for that vehicle in that week. In my report grand total is coming as 7000. see the example below

Ex:

Date                          Allowance

19/11/2018                    7000

20/11/2018                    7000

21/11/2018                    7000

22/11/2018                    7000

23/11/2018                    7000

------------------------------------------

Grand Total                   7000

------------------------------------------

Actually for the entire week the allowance for that vehicle should come as 35000. How can i change only grand total as sum but every day it should be average.

• ###### 1. Re: Grand Total Calculation Not Correct

By default whatever the aggregation you are using on the measure, based on the aggregation the Grand total will be computed.

In your case when you're applying average for allowance for each day, the grand total is also taking the average of the values available on the columns.

You can change the grand total aggregation manually (sum in your case) by simply right click on the measure.

Hope this helps! Plz mark my response as correct if this solve your issue.

3 of 3 people found this helpful
• ###### 2. Re: Grand Total Calculation Not Correct

Thanks. It's working!