Folks,
I am finding out about WebFOCUS and it's idiosyncrasies with rounding. I have a simple table that effectively holds numerator and denominator fields that I calculate to a percent using a Define statement (as a P8 so rounding will go up/down as normal). I am trying to do a simple ON BYFIELD SUB-TOTAL AVE. PERCENT at the end to average out those Percents, but it does not round as expected. Short of a manual COMPUTE, how can I easily force the formatting to P8? I've been reading years old posts all morning, and I just can't believe that we're still working around the same old problems.

DEFINE FILE VW_INDICATORMETRICVALUES_NUMDEM
	QUARTER/I4 = IF MONTH FROM 10 TO 12 THEN 1
				 ELSE IF MONTH FROM 1 TO 3 THEN 2
				 ELSE IF MONTH FROM 4 TO 6 THEN 3
				 ELSE 4;

	QUARTERA/A1 = FTOA(QUARTER, '(I4)', QUARTERA);

	QUARTERLONG/A11 = IF QUARTER EQ 1 THEN QUARTERA | 'st Quarter'
				 ELSE IF QUARTER EQ 2 THEN QUARTERA | 'nd Quarter'
				 ELSE IF QUARTER EQ 3 THEN QUARTERA | 'rd Quarter'
				 ELSE QUARTERA | 'th Quarter';

	FISCALYEAR/I4 = IF QUARTER EQ 1 THEN YEAR + 1 ELSE YEAR;

	PRINTMONTH/A2 = EDIT(MONTH, '$$$$$$$$$99');
	PRINTYEAR/A4  = EDIT(YEAR, '$$$$$$$9999');
	PRINTDATE/A7  = PRINTMONTH | '/' | PRINTYEAR;

	PERCENT/P8    = (NUM_VALUE / DEM_VALUE) * 100;
	
END

TABLE FILE VW_INDICATORMETRICVALUES_NUMDEM
PRINT
	NUM_VALUE 
	DEM_VALUE 
	PERCENT

	BY ORGUNITSHORTNAME 
	BY QUARTER
	BY MONTH NOPRINT
	BY PRINTDATE

WHERE ORGENTITYNO EQ '70';
WHERE INDICATORNAME EQ 'MedRec';
WHERE FISCALYEAR EQ 2010;

-* Works pretty Good but AVE. PERCENT does not round.
ON ORGUNITSHORTNAME RECOMPUTE SUB-TOTAL SUM. NUM_VALUE SUM. DEM_VALUE AVE. PERCENT AS '* FISCAL YEAR :'
ON QUARTER RECOMPUTE SUB-TOTAL SUM. NUM_VALUE SUM. DEM_VALUE AVE. PERCENT AS '* QUARTER :'
ON TABLE RECOMPUTE

END
-EXIT

- ABT

This message has been edited. Last edited by: Kerry,

No replies, huh?

- ABT

Nope, after all these years I still haven't seen WebFOCUS perform "magic".

How are we suppose to assist if you don't use a common data file from IBISAMP?

You need to use RECAP and SUBFOOT...

@Tom :-) Got me there, touche'. I'll give that a try and if I can't get it off the ground, I'll post back something with CAR/Employee. Thanks!

- ABT