I am trying to create a percentage toggle where my percentage is to be set as a decimal. I am having problems converting my percent as integer. I created an example through car.

SUM PCT.CAR.BODY.SALES/F6.2% WITHIN BODYTYPE
BY CAR.BODY.BODYTYPE
BY CAR.CARREC.MODEL
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT 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 GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
END

I'm trying to figure out the percentage for each individual slice as it meets a business requirement. Any suggestions on what to do? I tried formatting sale as a float and a decimal and didn't have any luck. Thoughts?

This message has been edited. Last edited by: <Emily McAllister>,

Your confusing me, by posting chart code, looking for a percentage, which I would think is a report.

TABLE FILE CAR
SUM PCT.CAR.BODY.SALES/D6% WITHIN BODYTYPE
BY CAR.BODY.BODYTYPE
BY CAR.CARREC.MODEL
END

What you're actually doing by redefining the format of the field is introducing a new field.
You'd better put that redefine in a define and use the defined field without any reformatting.
That way you're always sure of what GRAPH is using.
Now it is not clear if it uses the original field or the reformatted one.

GamP-

Thanks, that fixed my problem. I had created a new define but I was reformatting within the GRAPH as well. Appreciate your help.

NickSmith