﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>FusionCharts Forum / FusionCharts v3 / Using FusionCharts / General usage  / Number Formatting Problem / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>FusionCharts Forum</description><link>http://www.fusioncharts.com/forum/</link><webMaster>support@fusioncharts.com</webMaster><lastBuildDate>Fri, 10 Oct 2008 17:26:48 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Number Formatting Problem</title><link>http://www.fusioncharts.com/forum/Topic6127-28-1.aspx</link><description>This XML seems to give an error - can you please resend a valid one at support [at] fusioncharts.com</description><pubDate>Sun, 18 May 2008 09:55:08 GMT</pubDate><dc:creator>Pallav</dc:creator></item><item><title>RE: Number Formatting Problem</title><link>http://www.fusioncharts.com/forum/Topic6127-28-1.aspx</link><description>&lt;FONT size=2&gt;&lt;P&gt;&lt;STRONG&gt;Please find the xml file as below:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&amp;gt;&amp;lt;chart xaxisname="Month" useRoundEdges="1" showValues="0" showFCMenuItem="0" showBorder="0" sFormatNumberScale="1" numberScaleValue="1000,1000,1000" numberScaleUnit="K,M,B" formatNumber="1" decimals="2" bgColor="FFFFFF" SYAxisName="Sales Value&amp;amp;#xA;Sales Target" PYAxisName="Actual to Target Sales %"&amp;gt;&amp;lt;categories&amp;gt;&amp;lt;category label="DEC"&amp;gt;&amp;lt;/category&amp;gt;&amp;lt;category label="NOV"&amp;gt;&amp;lt;/category&amp;gt;&amp;lt;category label="OCT"&amp;gt;&amp;lt;/category&amp;gt;&amp;lt;/categories&amp;gt;&amp;lt;dataset seriesName="Actual to Target Sales %"&amp;gt;&amp;lt;set value="0" toolText="Actual to Target Sales %&amp;amp;amp;lt;BR&amp;amp;amp;gt;DEC&amp;amp;amp;lt;BR&amp;amp;amp;gt;0.00"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;set value="251.27" toolText="Actual to Target Sales %&amp;amp;amp;lt;BR&amp;amp;amp;gt;NOV&amp;amp;amp;lt;BR&amp;amp;amp;gt;251.27"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;set value="251.66" toolText="Actual to Target Sales %&amp;amp;amp;lt;BR&amp;amp;amp;gt;OCT&amp;amp;amp;lt;BR&amp;amp;amp;gt;251.66"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;/dataset&amp;gt;&amp;lt;dataset seriesName="Sales Value" renderAs="Line" parentYAxis="S"&amp;gt;&amp;lt;set value="48701.99" toolText="Sales Value&amp;amp;amp;lt;BR&amp;amp;amp;gt;DEC&amp;amp;amp;lt;BR&amp;amp;amp;gt;48,701.99"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;set value="31360527.05" toolText="Sales Value&amp;amp;amp;lt;BR&amp;amp;amp;gt;NOV&amp;amp;amp;lt;BR&amp;amp;amp;gt;31,360,527.05"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;set value="31409229.04" toolText="Sales Value&amp;amp;amp;lt;BR&amp;amp;amp;gt;OCT&amp;amp;amp;lt;BR&amp;amp;amp;gt;31,409,229.04"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;/dataset&amp;gt;&amp;lt;dataset seriesName="Sales Target" renderAs="Line" parentYAxis="S"&amp;gt;&amp;lt;set value="0" toolText="Sales Target&amp;amp;amp;lt;BR&amp;amp;amp;gt;DEC&amp;amp;amp;lt;BR&amp;amp;amp;gt;0.00"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;set value="12480918" toolText="Sales Target&amp;amp;amp;lt;BR&amp;amp;amp;gt;NOV&amp;amp;amp;lt;BR&amp;amp;amp;gt;12,480,918.00"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;set value="12480918" toolText="Sales Target&amp;amp;amp;lt;BR&amp;amp;amp;gt;OCT&amp;amp;amp;lt;BR&amp;amp;amp;gt;12,480,918.00"&amp;gt;&amp;lt;/set&amp;gt;&amp;lt;/dataset&amp;gt;&amp;lt;styles&amp;gt;&amp;lt;definition&amp;gt;&amp;lt;style type="font" size="10" name="MyFirstFontStyle" font="Arial" color="000000"&amp;gt;&amp;lt;/style&amp;gt;&amp;lt;style type="font" name="toolName" isHTML="1" bold="1"&amp;gt;&amp;lt;/style&amp;gt;&amp;lt;/definition&amp;gt;&amp;lt;application&amp;gt;&amp;lt;apply toObject="Caption" styles="MyFirstFontStyle"&amp;gt;&amp;lt;/apply&amp;gt;&amp;lt;apply toObject="TOOLTIP" styles="toolName"&amp;gt;&amp;lt;/apply&amp;gt;&amp;lt;/application&amp;gt;&amp;lt;/styles&amp;gt;&amp;lt;/chart&amp;gt;&lt;/P&gt;&lt;P&gt;kindly let me know the solution.&lt;/P&gt;&lt;/FONT&gt;</description><pubDate>Mon, 12 May 2008 08:21:53 GMT</pubDate><dc:creator>Sanjay</dc:creator></item><item><title>RE: Number Formatting Problem</title><link>http://www.fusioncharts.com/forum/Topic6127-28-1.aspx</link><description>Hi,&lt;br&gt;&lt;br&gt;Can you please post the output XML as attachment?</description><pubDate>Mon, 12 May 2008 06:17:03 GMT</pubDate><dc:creator>Pallav</dc:creator></item><item><title>Number Formatting Problem</title><link>http://www.fusioncharts.com/forum/Topic6127-28-1.aspx</link><description>&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"&gt;&lt;FONT color=#000000&gt;Hi,&lt;?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"&gt;&lt;FONT color=#000000&gt;I am using the ScrollCombiDY2D.swf in my chart and doing some number formatting internally like I am plotting this number “1754.37” and showing it on PYAxis. Now its in thousand format that’s why I am getting the on PYAxis with suffix like in “3.6K” by default. But when I convert it to Million its coming “1.75437603” and in this case I am not getting anything suffix like “M” and for Billion its forming “0.00175437603” here I should expect like “B” suffix to the PYAxis.&lt;o:p&gt;&lt;/o:p&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"&gt;&lt;FONT color=#000000&gt; &lt;o:p&gt;&lt;/o:p&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"&gt;&lt;FONT color=#000000&gt;Here I am giving the following coding which I am following.&lt;o:p&gt;&lt;/o:p&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"&gt;&lt;FONT color=#000000&gt; &lt;o:p&gt;&lt;/o:p&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #0000c0; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;chart&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;.setShowValues(&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #2a00ff; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;"0"&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;);&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #0000c0; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;chart&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;.setDecimals(&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #2a00ff; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;"2"&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;);&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #0000c0; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;chart&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;.setFormatNumber(&lt;/SPAN&gt;&lt;B&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #7f0055; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;new&lt;/SPAN&gt;&lt;/B&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt; BigDecimal(1));&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #0000c0; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;chart&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;.setSFormatNumberScale(&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #2a00ff; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;"1"&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;);&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #0000c0; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;chart&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;.setSFormatNumberScale(&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #2a00ff; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;"1"&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;);&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #0000c0; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;chart&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;.setNumberScaleValue(&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #2a00ff; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;"1000,1000,1000"&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;);&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #0000c0; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;chart&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;.setNumberScaleUnit(&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: #2a00ff; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;"K,M,B"&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;);&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt; &lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;I need to display on PYAxis like “M” &amp;amp; “B” Format.&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt; &lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;Kindly give me some solutions for this issue.&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt; &lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt"&gt;Thanks &amp;amp; Regards,&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"&gt;Sanjaya Kumar Das&lt;/SPAN&gt;</description><pubDate>Wed, 07 May 2008 09:23:03 GMT</pubDate><dc:creator>Sanjay</dc:creator></item></channel></rss>