When modeling a report that includes grand totals, always take an extra minute or two to build a summary that totals all of your extracted values to ensure that you’ve modeled the data as accurately as you think you have. You’ll be happy to see that the totals balance to the report.

But you’ll be thrilled to see that they don’t, when you thought you got it right the first time.

That little extra bit of development time is nothing when weighed against the thought that you might have started working with incorrect data, had you not checked your work.