Zeros not displaying on Data Labels

building reports desktopintelligence
1

I have values in a chart that are 0. I have the formatting option turned on to display 0.0% when the value is zero. It is simply not displaying on the chart. Any other value displays perfectly. Any suggestions welcome.

BIDude :us: (BOB member since 2009-05-14)

2

Charts don’t display 0s, even if you format the number that way. :roll_eyes: You’ll need to create a variable that converts 0s into another number, such as .01, using If. Use a number that is small enough that it will still look like 0 on the chart.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Does not work for percentages though the lowest i can get it to go is .1%…it will not display 0%

 =  If (<SLAAchieved(Sev 1 and 2 DC Resolve)>) > 0 Then (<SLAAchieved(Sev 1 and 2 DC Resolve)>/<ValidSLA(Sev 1 and 2 DC Resolve)>) Else 0.001

BIDude :us: (BOB member since 2009-05-14)

4

Have you tried .0001? On your chart, does it look like 0?

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

5

it simply wont display anything with that vaule.

BIDude :us: (BOB member since 2009-05-14)

6

Got it…i had to put .0004 to make it work! Thanks so much!

BIDude :us: (BOB member since 2009-05-14)