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.