-*COMPONENT=Define_car DEFINE FILE baseapp/car DF_Profit_Amount/D12M=CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST ; DF_Profit_Percent/D6.2%=((CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST) / CAR.BODY.DEALER_COST ) * 100; END ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD -DEFAULTH &WF_HTMLENCODE=OFF; SET HTMLENCODE=&WF_HTMLENCODE SET ARGRAPHENGINE=JSCHART -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT SET EMBEDHEADING=ON SET GRAPHDEFAULT=OFF -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE baseapp/car -* Created by Info Assist for Graph SUM CAR.BODY.RETAIL_COST CAR.BODY.DEALER_COST DF_Profit_Amount DF_Profit_Percent/D6.1% BY CAR.CARREC.MODEL WHERE CAR.CARREC.MODEL LE '2002 2 DOOR AUTO'; ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET GRWIDTH 1 ON GRAPH SET AUTOFIT ON ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET LOOKGRAPH BAR ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * *GRAPH_SCRIPT setPieDepth(0); setPieTilt(0); setDepthRadius(0); setPlace(true); setCurveFitEquationDisplay(false); *END INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $ TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $ TYPE=DATA, COLUMN=N2, BUCKET=y-axis(1), $ TYPE=DATA, COLUMN=N3, BUCKET=y-axis(1), $ TYPE=DATA, COLUMN=N4, BUCKET=y-axis(1), $ TYPE=DATA, COLUMN=N5, BUCKET=y-axis(2), $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); setSeriesType(3,2); setDataTextPosition(1); setDisplay(getDataText(3), true); setTextFormatPreset(getY2Label(),2); setDisplay(getLegendArea(),false); setCustomDataText(getDataText(3), true); setTextFormatPreset(getDataText(3), 0); setTransparentBorderColor(getSeries(*), true); setSeriesType(2,1); *GRAPH_JS_FINAL "pieProperties": { "holeSize": "0%" }, "riserBevel": "cylinder", "agnosticSettings": { "dual": true, "chartTypeFullName": "Bar_Clustered_Dual_Axis" } *END ENDSTYLE END -RUNIt's gotta be something simple, right?This message has been edited. Last edited by: FP Mod Chuck,
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
-*COMPONENT=Define_car DEFINE FILE baseapp/car DF_Profit_Amount/D12M=CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST; DF_Profit_Percent/D6=(CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST) / CAR.BODY.DEALER_COST; END ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD -DEFAULTH &WF_HTMLENCODE=OFF; SET HTMLENCODE=&WF_HTMLENCODE SET ARGRAPHENGINE=JSCHART -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT SET EMBEDHEADING=ON SET GRAPHDEFAULT=OFF -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE baseapp/car -* Created by Info Assist for Graph SUM CAR.BODY.RETAIL_COST CAR.BODY.DEALER_COST DF_Profit_Amount DF_Profit_Percent BY CAR.CARREC.MODEL WHERE CAR.CARREC.MODEL LE '2002 2 DOOR AUTO'; ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET GRWIDTH 1 ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET LOOKGRAPH BAR 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/ibi_themes/Warm.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $ TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $ TYPE=DATA, COLUMN=N2, BUCKET=y-axis(1), $ TYPE=DATA, COLUMN=N3, BUCKET=y-axis(1), $ TYPE=DATA, COLUMN=N4, BUCKET=y-axis(1), $ TYPE=DATA, COLUMN=N5, BUCKET=y-axis(2), $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); setTransparentBorderColor(getSeries(*), true); setDataTextPosition(1); setCustomDataText(getDataText(3), true); setTextFormatPreset(getDataText(3), 4); setSeriesType(3,2); setTextFormatPreset(getY2Label(),4); setFontName(getDataText(3), "ARIAL BLACK"); setFontSizeAbsolute(getDataText(3), true); setFontSizeInPoints(getDataText(3), 12); setPlaceResize(getDataText(3), 0); setDisplay(getDataText(3), true); setPieFeelerTextDisplay(1); *GRAPH_JS_FINAL "pieProperties": { "holeSize": "0%" }, "riserBevel": "cylinder", "agnosticSettings": { "dual": true, "chartTypeFullName": "Bar_Clustered_Dual_Axis" } *END ENDSTYLE END -RUN
DF_Profit_Percent/D6
DF_Profit_Percent/D6.2
quote:Originally posted by David Sibert:
In the past I put the percent sign in the Label. So in this case DF_Profit_Percent %.
DF_Profit_Percent % 0.20
DF_Profit_Percent % 20.55