Can you attach workbook?
Are you trying to total an LOD expression - if so it will give you the calculation based on the independent values in the grand total row - it will not sum the calcualted field
For that you would need to do a Fixed :sum( calculated field)
Let me know if that helps
Are you displaying averages by any chance? If so, the grand total would also be an average and not a sum as you may expect.