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.