Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I summarize the results of a maximum formula?

Status
Not open for further replies.

suefhmis

Instructor
Jan 24, 2002
25
0
0
US
I'm using CR 8.5 and I've created the following formula:

Maximum ({query.principal}, {query.endowment_nbr})

and placed it in my group #1 footer. Is it possible to get a summary of this field? CR won't allow me to create a summary, grand total, or running total.
 
You can do it with a formula placed in the group footer:

Global NumberVar S;
S:=S+Maximum ({query.principal}, {query.endowment_nbr});
S
 
I was actually able to achieve my desired result by using a Running Total - Sum - Evaluate on change of group function. Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top