Sum for a date range

[WebiGirl]

My report is summing 4 columns, by geographic area (each area in its own section), for oil and gas production for wells, and I am putting the sums at the top of the table, so the finance people can see at a glance what the sum for each of the variables was.

Because the date range for this report will be a month at a time, I have 30 days' data for each section.

Can I put a formula in each of the measures' column that sums for all the days for each well? So that instead of seeing the amount/measure for each day, it would add all 30 days of production up for each well and put it in the same line for oil and gas? instead of showing each day?

 

[lbass]

This is hard to follow. Please show us how the current report is displaying and identify the report sections, including identifying the fields you are grouping on. Then show us a sample of how you would like it to display.

-LB

 

[WebiGirl]

The report is like this:

SUM: 1,295 2,478
Product Date Completion Name Grs Oil Grs Gas
8/22/09 Well #1 858 985
8/22/09 Well #2 87 1493
8/23/09 Well #1 150 300
8/24/09 Well #2 200 180


Can I do this? (summing on the line for each well for the whole month of data)
SUM:
Product Date Completion Name Grs Oil Grs Gas
8/22/09-8/24/09 Well #1 1008 1285
8/22/09-8/24/09 Well #2 287 1673

 

[lbass]

You could insert a second group on the Well field and then right click on your oil and gas fields and insert a sum at the well group level and then suppress teh detail section.

Or, if you need to have the detail displayed as is, you could insert a crosstab in the report header that uses well as the row field with no column field, but two summaries, sum of gas and sum of oil.

-LB