Incorrect Grand Summary

Incorrect Grand Summary


In the above picture I have a table of lead conversions sorted by lead source. The 'Total Cost of Leads' and 'Profit' columns are report formula columns. The data in the column is correct but the grand summary at the bottom is applying the formula to the grand summary information at the bottom instead of just totalling what's in the column. Is there any way to fix this as it is important information to see?

Thanks,

James