Option to remove 0s in Report Builder data blocks | Community
Skip to main content
lldr59828
lldr59828
Level 2
June 1, 2011
New

Option to remove 0s in Report Builder data blocks

  • June 1, 2011
  • 1 reply
  • 1354 views

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 reply

ottog85683
ottog85683
January 3, 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.

Terms & ConditionsAccessibility statement

Loading footer...