Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Option to remove 0s in Report Builder data blocks

Avatar

Avatar
Boost 5
Level 3
lldr59828
Level 3

Likes

40 likes

Total Posts

12 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
lldr59828
Level 3

Likes

40 likes

Total Posts

12 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
lldr59828
Level 3

31-05-2011

Hi

 

I would like very much to have the option of removing 0s in ReportBuilder data blocks. Today you can not avoid 0s if you have more than one metric in a data block!

It is not so convenient when creating Excel graphs as the graphs look much better without zeros.

 

cheers

lldr

1 Comment

Avatar

Avatar
Applaud 5
Level 1
ottog85683
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
ottog85683
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile
ottog85683
Level 1

02-01-2012

This would only be partially heplful (i.e. when plotting completely raw data blocks), as there is an Excel bug that prevents any cell formula from returning a value that will be treated the same way as a truly empty cell by the chart functions.

 

I once found a bizarrely complicated workaround, recommended by an Excel guru, that requires you to create a named range that refers to a list of calls to the Excel "indirect" function. (The named range is then explicitly specified as the data range for a chart seires.) This does work as intended, but it is a lot of work just in order to improve the looks of a chart…

 

Perhaps one could create a VBA macro that automates the workaround.