Totaling Sums for Price and COMM

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

I am trying to find a way to total Sums for two Fields, Price and COMM.

This must be an easy fix, just haven’t done this in a while and I think I
forgot a step.

In my Report, I have the following:
Page Header, I have TDATE (for TradeDate), CUST (for Customer), B/S
(Buy/Sell), C/P (for Call/Put), Quantity, Symbol, Price, and COMM.

In CUST Header, I have CUST

In Detail, I have TDATE, CUST, B/S, C/P, Quantity, Symbol, Price, and COMM.

In TDATE Footer, I have =Sum([Quantity]), =Sum([Price]) =Sum([COMM])

Now, I’m trying to figure out how to sum those last two values; Sum all
[Price] and Sum all [COMM]. I suspect I have to add another footer, but I’m
not sure where to do this, or at what level. I’ve tried a few different
things and haven’t had any success yet.

I’d appreciate any insight!

Thanks,
Ryan--
 
Ryan,
It sounds like you want to add a REPORT footer (on the menu, click View,
Report Header/Footer). Then you can add your fields for the totals for
the entire report.
Hope that helps,
Darrell
 
ryguy7272 said:
I am trying to find a way to total Sums for two Fields, Price and COMM.

This must be an easy fix, just haven’t done this in a while and I think I
forgot a step.

In my Report, I have the following:
Page Header, I have TDATE (for TradeDate), CUST (for Customer), B/S
(Buy/Sell), C/P (for Call/Put), Quantity, Symbol, Price, and COMM.

In CUST Header, I have CUST

In Detail, I have TDATE, CUST, B/S, C/P, Quantity, Symbol, Price, and COMM.

In TDATE Footer, I have =Sum([Quantity]), =Sum([Price]) =Sum([COMM])

Now, I’m trying to figure out how to sum those last two values; Sum all
[Price] and Sum all [COMM]. I suspect I have to add another footer, but I’m
not sure where to do this, or at what level. I’ve tried a few different
things and haven’t had any success yet.
Click to expand...


I think you want to use the same expressions in the Report
Header/Footer
 
Ah! That works! It's pretty easy when you know what to do!
Thanks for jumping in Darrel and Marshall!!

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


Marshall Barton said:
ryguy7272 said:
I am trying to find a way to total Sums for two Fields, Price and COMM.

This must be an easy fix, just haven’t done this in a while and I think I
forgot a step.

In my Report, I have the following:
Page Header, I have TDATE (for TradeDate), CUST (for Customer), B/S
(Buy/Sell), C/P (for Call/Put), Quantity, Symbol, Price, and COMM.

In CUST Header, I have CUST

In Detail, I have TDATE, CUST, B/S, C/P, Quantity, Symbol, Price, and COMM.

In TDATE Footer, I have =Sum([Quantity]), =Sum([Price]) =Sum([COMM])

Now, I’m trying to figure out how to sum those last two values; Sum all
[Price] and Sum all [COMM]. I suspect I have to add another footer, but I’m
not sure where to do this, or at what level. I’ve tried a few different
things and haven’t had any success yet.
Click to expand...


I think you want to use the same expressions in the Report
Header/Footer
Click to expand...
 
Back
Top