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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Option to remove 0s in Report Builder data blocks

Avatar

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

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.