how do I sum a minimum value in a report?

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

Guest

I have a Contact ID Footer text box that gives me this value:
=Min([Pledge Amount])

I would like the report footer to sum the values in these footer boxes, in
other words, sum the minimum value of "Pledge Amount", not every instance
where "Pledge Amount" appears.

How do I modify the current formula in my report footer, which reads:
=Sum([Pledge Amount])
I want ONLY the minimum values in this field to sum

Thank in advance,
Brenda
 
Create a new text box in the ContactID footer

Name: txtMinPledge
Control Source: =Min([Pledge Amount])
Running Sum: Over All
Visible: NO

Add a text box to your report footer:

Control Source: =txtMinPledge
 
Back
Top