6 Replies Latest reply: Mar 8, 2017 12:11 PM by Apolo Takeshi Batista

# How can i Remove left Zeros in a chart?

For instance I have a number that is 0.10, and I would like to show .1

I know i can go to properties/ number and choose show one decimal.

so it will show 0.1, but I want it to exhibit .1 instead.

Do you guys have any idea?

• ###### Re: How can i Remove left Zeros in a chart?

Where do you want to display this ?

May be try like:

= Subfield(Yourfield, '0',2)

• ###### Re: How can i Remove left Zeros in a chart?

thanks but it doesn't work

I have something like:

Field1 / Field2

and the result is <1.

So the results are something like 0.1, 0.1, 0.2, 0.3

And I'm showing them in a bar chart above the bars.

So I need them to use less space because they amount together and the user can't see much ='(

I need a bar that shows

.1 .3 .4 .4 .5

and when i hover my mouse I can show in text pop up the correct number (i.e. 0.15)

I just don't know how to configure the .1, .4 , etc.

• ###### Re: How can i Remove left Zeros in a chart?

Did you try this?

= Subfield(Num(Field1/Field2, '0.00'), '0', 2)

• ###### Re: How can i Remove left Zeros in a chart?

I was inspired by your solution and could solve the problem like this:

=SubField(Num(\$(vCalculation),'%.#'),'0',2)

Somehow with '0.00' wasn't working so I changed it to '%.#' and it worked like i wanted!

Great help =DD

• ###### Re: How can i Remove left Zeros in a chart?

Hi Apolo

MACRO:

• ###### Re: How can i Remove left Zeros in a chart?

Great solution! but it would only work for me if I was using static data!

my data keeps changing all the time ;/ so I got to do the math according to users selection!

But thx!