To be honest, I hesitate to download 40MB file.
The question seems simple.
Could you reduce the size of attached file with filtering data source before extract.
What are your expected results?
I agree with Shin, the workbook should be a lot smaller, but try this :
Period Cost = sum([Distance])/avg([Fuel Economy (Kpl)])*[Price of Fuel]
Savings = [Period Cost (£)]-sum([Benchmark Cost (£)])
But I'm guessing because you don't give an example of what you're trying to achieve.
Thanks Chirs, but calculation doesn't work.
In theory the Period cost should be +/- % difference in KPL of the Benchmark Cost
It works in mine
Anyway, there might be something wrong with the data because most of your calculations are not aggregated (ie not using SUM, AVG, etc...) and [Location Benchmark] is NULL
Can you review the data and maybe just have a handful of records to help illustrate the problem and then explain what the answer should be ?