Number Format Issue

[#1]

Hi Everyone,

I have created a Bar chart to analyze the sales in different cities,  where the problem is when Sales value is displayed in bar chart for a city say A the sales value is 7.85(after Formatting) , but when i export the bar chart to excel it gives the sales value as 7.85236214.

Can any one advice the reason behind this......? & suggest a way to rectify this issue.

Thanks

[its_anandrjs]

Hi Sathis,

You have to use =Num(SUM(Sale),'#,##0.00') because after decimal you need 2 digits you can achieve the same from the chart properties  >> Number >> Fixed to >> 2 Decimals.

And NUM is worked like when you pass SUM(Sale) expression values then the values get formatted after decimal place value 2 digits and you can increase this value also.

Hope this helps

[MK_QSL]

Dear Sathis, I think my friend Anand has already written the logic.

Thanks Anand...

[#4]

OK its clear .....

[#5]

Its Clear now manish & thank you anand chouhan