I'm trying to give a custom format to a legend. I would like the output of the numbers "$###,###.##" but I simply can't find a way

 ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='400.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM CNT.CAR.COMP.CAR
CNT.CAR.ORIGIN.COUNTRY NOPRINT
CAR.BODY.SALES
BY CAR.BODY.SALES
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT 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 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH MEKKO
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0); 
setCurveFitEquationDisplay(false); 
setPlace(true); 
*END
INCLUDE=esdeflt.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setColorMode(2);
setTextFormatPattern(getDataText(),"$###,###.##");
setTextFormatPreset(getDataText(),5);
setDisplay(getDataText(),true);
setSquareMarkers(true);
*END
ENDSTYLE
END 

Web Focus 8105

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

Rgar,

Welcome to Focal Point.

Did you try a search within Focal Point?

Please review the following links:

Customizing Data Text

Formatting Numbers and Numeric Labels

Let us know if that helps.

Thank you for using Focal Point.
Tamra Colangelo
IBI Focal Point Moderator