If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum including all records
Hi,
I am having a problem with summing of calculated fields. My report is to sum the costs for each Purchase Order (PO) listed on the form in the PO footer of the report. Now the data that I am pulling this from will have multipleinstances of the PO in the details but I just want the sum of the Quantity of the PO (POqty) * Price on the PO. I am performing this summing on the PO Footer but it is summing all of the details for that PO giving an inflated total. I just want the totals that is shown in the PO Header to be summed at the bottom of the report and not every line on the report. I am new to this type of summing so please take this in consideration when replying, and as always THANKS IN ADVANCE!!!! Chip |
#2
|
|||
|
|||
Sum including all records
Chip,
One SUM error I come across is based on which section I place the statement: =Sum([PO_Detail_Val]) I could put it in the Report Header, Page Header, Detail Section Header, etc., and I'll get different results. Though you probably knew that one. Maybe this is the problem though ... you might be wanting this =Sum([PO_Header_Val]) instead of this: =Sum([PO_Detail_Val]) Let me know if this helps. "Chip" wrote: Hi, I am having a problem with summing of calculated fields. My report is to sum the costs for each Purchase Order (PO) listed on the form in the PO footer of the report. Now the data that I am pulling this from will have multipleinstances of the PO in the details but I just want the sum of the Quantity of the PO (POqty) * Price on the PO. I am performing this summing on the PO Footer but it is summing all of the details for that PO giving an inflated total. I just want the totals that is shown in the PO Header to be summed at the bottom of the report and not every line on the report. I am new to this type of summing so please take this in consideration when replying, and as always THANKS IN ADVANCE!!!! Chip |
Thread Tools | |
Display Modes | |
|
|