Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.