How to refer to summary items
Robert J.M. Edis
robert.edis@creatcomp.com
Thu, 9 Mar 2000 19:44:34 -0500
G'day Leonard
How are you producing the subfile? Quiz or QTP?
In QTP you can create a uniquely named temp item for each summary operation,
eg.
TEMP tot_elapsed_avg
TEMP tot_elapsed_min
TEMP tot_elapsed_max
ITEM tot_elapsed_avg = AVERAGE tot_elapsed AT sortkey
ITEM tot_elapsed_min = MINIMUM tot_elapsed AT sortkey
...
Or in Quiz use a DEFINE to create a new item for each operation, e.g.
DEFINE tot_elapsed_avg = tot_elapsed
DEFINE ...
REPORT SUMMARY &
AVERAGE tot_elapsed_avg ...
This way each item has a unique name that use can refer to when reading the
subfile.
Blue
-----Original Message-----
From: Leonard_Berkowitz@harvardpilgrim.org
To: powerh-l@lists.swau.edu
Sent: 3/9/00 3:45 PM
Subject: How to refer to summary items
PowerHouse 8.19C on HP3000 (MPE/iX)
I have a subtotal with a bunch of items including three that are summary
operations on the same field: AVERAGE, MINIMUM and MAXIMUM. I can access
the
subfile and print out this data with REPORT ALL.
Tot Tot Tot
Elapsed Elapsed Elapsed
(AVERAGE) (MINIMUM) (MAXIMUM)
but how would I manipulate them, e.g, in a DEFIINE, in a REPORT GROUP,
etc.?
My ultimate goal is to formate these fields into HH:MM so that the
information
is readable without the user needing to do the math. I can do this, with
DEFINEs
at the item level, but not for the summary level.
Thanks,
===================
Leonard S. Berkowitz
Perot Health Care Systems
(Harvard Pilgrim Health Care account)
voice: 617-509-1212
fax: 617-509-3737 (eff. 2/15/2000)
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
= =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.