How to show the values in Group Axis without decimals

[PankajVerma]

Hi I have a graph plotted between "No of Suppliers" and the "Average Deflation". Both the Values are numbers.

I want to show the No of Suppliers as 1,2,3,4 Not like 1.00,2.00,3.00 ..... in group axis of the graph.

I see that I have the option for formatting of the values of Data Axis but not for the group Axis.

If I make one formula and convert the "No Of Suppliers" in text , with no decimal, and plot the graph between this formula and Average Deflation then it shows me the values in group axix as 1,2,3,4 but the sorting changes as the formula is text.

Please suggest what to do?

 

[Ngolem]

when you convert the numbers do you pad with blanks ?

When I convert numbers to Strings I decide the maximum size of the number (ie. 999)
then my conversion forumla is

Space(3 - length(totext({table.numbers},0,"","&quot) + totext({table.numbers},0,"","&quot

this makes it so that they sort properly

perhaps this will work in your case

Jim

 

[PankajVerma]

This Works perfectly ..Thanks Jim