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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Total Count of Formula Fields

Status
Not open for further replies.

redtoad

Programmer
Jan 28, 2002
51
US
I have four formula fields that pass a number and I want to get a total count for these fields. What is the best way to do that?

Let's say the fields are {@a} {@b} {@c} and {@d}.

Thanks

 
Insert a grant total count field - Rt click on the field, insert grand total, make it a count operation. Please be advised that count will not count a null value. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com
 
What I ended up doing was creating a formula field and added up the Sum's of the Summed formula fields in question(if that makes sense). I also added a condition to assign null values to zero. That approach seems to have worked. Thanks for your help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top