GRAPH FILE CAR
SUM 
    COMPUTE PP/D6 = (DEALER_COST * 100 / RETAIL_COST) + 6;
BY COUNTRY
ON TABLE HOLD AS H1
END
-RUN

TABLE FILE H1
SUM 
    MIN.PP
    MAX.PP
ON TABLE HOLD AS MINMAX FORMAT ALPHA
END
-RUN
-READ MINMAX &VALMIN.6 &VALMAX.6

GRAPH FILE H1
SUM PP
BY COUNTRY
ON GRAPH SET GRAPHSTYLE *
setY1ScaleMin(&VALMIN);
setY1ScaleMax(&VALMAX);
setY1MustIncludeZero(false);
ENDSTYLE 
END

quote:

-READ MINMAX &VALMIN.6 &VALMAX.6

SET ASNAMES = MIXED
ENGINE INT CACHE SET ON
-DEFAULTH &MINSALES = _FOC_NULL;
-DEFAULTH &MAXSALES = _FOC_NULL;
-DEFAULTH &CAR = _FOC_NULL;

-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';

TABLE FILE ibisamp/car
SUM CAR.BODY.SALES
BY CAR.COMP.CAR
WHERE CAR.BODY.SALES GT 0;
ON TABLE HOLD AS MYHOLD FORMAT ALPHA
END
-RUN

TABLE FILE MYHOLD
PRINT SALES AS MAXSALES
BY HIGHEST 1 SALES
ON TABLE HOLD AS MYMAXSALES FORMAT ALPHA
END
-RUN

-READFILE MYMAXSALES
-RUN
-TYPE &MAXSALES;

TABLE FILE MYHOLD
PRINT SALES AS MINSALES
BY LOWEST 1 SALES
ON TABLE HOLD AS MYMINSALES FORMAT ALPHA
END
-RUN

-READFILE MYMINSALES
-RUN
-TYPE &MINSALES;
-*Doing this, because your lowest one, will not show up unless you drop below the min.
-SET &MINSALES = IF &MINSALES GT 1000 THEN (&MINSALES-1000) ELSE &MINSALES;
-*-EXIT

GRAPH FILE ibisamp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.SALES
BY CAR.COMP.CAR
WHERE CAR.BODY.SALES GT 0;
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setScaleMinAuto(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),&MAXSALES.EVAL);
setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(),10000.0);
setScaleMin(getY1Axis(),&MINSALES.EVAL);

*END
ENDSTYLE
END

-RUN

- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server

quote:

Originally posted by Tony A:

quote:

-READ MINMAX &VALMIN.6 &VALMAX.6

Firstly, correct this syntax. A -READ must be integer or alpha and have a trailing quote. You may have issues when you upgrade if you do not stick to documented syntax. Alternatively use HOLD and -READFILE.

e.g.
-READ MINMAX &VALMIN.I6. &VALMAX.I6.
-- or --
-READ MINMAX &VALMIN.A6. &VALMAX.A6.

Simple solution? Take your variables and round up or down using dialogue manager.

T