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