What function are you trying to remove?

The SUM?

I would of thought that Azure would come with the bulit in aggregating functions as standard.

http://msdn.microsoft.com/en-us/library/windowsazure/ee336248.aspx#aggregate

Azure does use the standard aggregating functions