[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

Title:	FOCUS, from INFORMATION BUILDERS

Moderator:	ZAYIUS::BROUILLETTE

Created:	Thu Feb 19 1987
Last Modified:	Mon May 05 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	615
Total number of notes:	1779

272.0. "AVERAGE WITH ACROSS?" by MIDCIM::LINDQUIST () Tue Oct 03 1989 13:53

Hi folks:
	I'm having a frustrating time trying to get an 'average'
	at ON time.

	What follows is my fex ..the AVE.NOR_PCT works fine
	but the ON MINIPBU RECOMPUTE does not print the average,
	it prints the sum of the individual AVE.NOR_PCT's.

TABLE FILE QVP
SUM MLPMIL NOPRINT AND COMPUTE NORAVG/D6.2 = AVE.NOR_PCT; AS ' '
BY MINIPBU NOPRINT
BY MODEL_DS 
ACROSS FYYR AS ' '
HEADING 
"WHATEVER.....
    "
ON MINIPBU  RECOMPUTE
END

	How do I get the average?

What I want:

	   FY90		FY91		FY92

MODEL1     70.0        70.0             70.0
MODEL2     50.0        50.0             50.0
  
MINIPBU    60.0        60.0             60.0

What I get:
	   120.0      120.0            120.0

T.R	Title	User	Personal Name	Date	Lines
272.1	WILL THIS WORK?	MILPND::MADDEN		`Fri Oct 06 1989 08:48`	3
	Will this work? ON MINIPBU RECAP PBU_NORAVG/D6.2=AVE.NOR_PCT;