Sum unique values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is a sample of my data:

PO# POTOTAL ITEM UNIT COST
04237 471.35 PC 460.00
04237 471.35 KEYBOARD 11.35
04239 713.52 MEMORY 713.52
04240 35000.00 SERVER 19000.00
04240 35000.00 STORAGE 16000.00

You can see there are multiple items on several P.O.'s and the data I
receive totals that data in the POTOTAL field. How can I get a total of
36184.87 in a footer using the POTOTAL field (totaling the unique values)?

I do have a total from the unit cost field also on the same report. These
should match.

Thanks for your time!

Mark
 
Mark said:
Here is a sample of my data:

PO# POTOTAL ITEM UNIT COST
04237 471.35 PC 460.00
04237 471.35 KEYBOARD 11.35
04239 713.52 MEMORY 713.52
04240 35000.00 SERVER 19000.00
04240 35000.00 STORAGE 16000.00

You can see there are multiple items on several P.O.'s and the data I
receive totals that data in the POTOTAL field. How can I get a total of
36184.87 in a footer using the POTOTAL field (totaling the unique values)?

I do have a total from the unit cost field also on the same report. These
should match.
Click to expand...

Group on the PO# field amd add a text box named
txtRunPoTotal in the PO# footer section. Bind the text box
to the PoTotal field and set its RunningSum property to Over
Group or Over All as appropriate. The footer section can be
invisible if you have no other use for it.

Your higher level group footer (or the report footer) can
then display the total in a text box with the expression
=txtRunPoTotal
 
Back
Top