More help with summary items

Chris Sharman Chris.Sharman@ccagroup.co.uk
Tue, 14 Mar 2000 15:53:14 +0000


>When I report the contents of the subfile, I can see the MINIMUM and MAXIMUM
>values per record working properly, up and down as the case may be. AVERAGE,
>however, is working just as if I had requested SUBTOTAL. Am I doing something
>incorrectly?

RTFM (or, indeed, my previous message on the subject).

To recap: 'average' writes two items to the subfile, both having the same name.
The first is subtotal, the second is a count. They can't be separately
referenced and are therefore of little use. You need to put subtotal in the
subfile, and a separate item to give you the count - eg

def recordcount int*4 = 1

rep sum ... recordcount subtotal ...

Then on the next pass the average is subtotal / recordcount.

Chris
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccastat.demon.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.