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

Calculate percentage of value returned by summary field

Status
Not open for further replies.

winstonep

Programmer
Feb 24, 2003
33
0
0
GB
This is perhaps a tricky one. I cannot get a count entered in a formula to return a group based result. It only returns the grand total. A summary field though works on a group based calculation. The snag is that I cannot access a summary field (or at least cannot work out how to) from a formula.

So basically, I want to get the results of one formula I have written as a sum of the results and then divide that by the total number of cases for the group to get the percentage (multiplied by 100 of course).

It something which should be easy but I just can't remember how or if I have done it before.

Paul Winstone
paul.winstone@logicacmg.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top