Hi, i have drawn a substantial amount of data off an sql server for
analysis in pivot tables. My data would resemble something like below

Reg Field A Field B Field C Field D
1 12 4 2 0
1 12 4 6 2

1 12 4 3 1

My Formula should something like

Comparrison = Average of B + (All of C values - All of D values)

I can't quite get this to work ina calculated field, How would i put
this as an expression in a calculated field? My experiments have always
treated B as a summed amount so i would end up with

Comparrison = 12 (sum of B not average) + (11-3) Not
Comparrison = 4 + (11-3)

Thanks


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=551355