B
Brenda Fry
In a contact ID Footer, I have a text box that contains:
=Min([Pledge Amount])
This gives me the number I want (the minimum of the amounts that appear in
the "Pledge Amount" fields). At the report footer, however, I would like to
sum all values in the contact ID footer text boxes rather than ALL "Pledge
Amounts" - I want ONLY the MIN of the "Pledge Amounts" to be summed in the
footer. Can you help me adjust the formula below to sum only the MINs??
=Sum([Pledge Amount])
Thanks in advance!
=Min([Pledge Amount])
This gives me the number I want (the minimum of the amounts that appear in
the "Pledge Amount" fields). At the report footer, however, I would like to
sum all values in the contact ID footer text boxes rather than ALL "Pledge
Amounts" - I want ONLY the MIN of the "Pledge Amounts" to be summed in the
footer. Can you help me adjust the formula below to sum only the MINs??
=Sum([Pledge Amount])
Thanks in advance!