Skip to Content
0
Former Member
Oct 26, 2007 at 01:27 PM

Crosstab total calculation

9 Views

Post Author: foghat

CA Forum: Formula

Hey all,I've got to be missing something simple here. The summarized fields in the report are being summed. The cross tab report looks something like this: 200701 200702 200703 Total Daily BOE. 1,400 1,000 1,200 3,600I want the Total to be the average, not the sum, of the summarized fields. So in the case above, Total should be 1,200. If I change the crosstab summary type to avg. all the values are calculated as an average, not just the total.Any thoughts?