Hi gramos14,

You are right! The individual amounts for the calculated field in the
data area are correct but the totals don't add these individual
amounts! Instead they add the individual components of the formula
before multiplying. Surely this is a bug because it makes no sense.
Does anyone know whether it is being fixed?

If you want totals (which of course you do) I assume you need to do all
calculations in your source data area. This calculated formula facility
appears essentially unusable.

Thanks for letting me know.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=528399