Possible to replace all nulls on report (all columns) with custom value?

Question

Does anyone know if there is a setting in answers to replace multiple columns containing null values with 0 (or some other custom value)?

A user put several reports on a dashboard page and now wants to see nulls replaced with 0's. Obviously we can add ifnull(fact,0) to each affected column but with the number of reports we're looking at, it would require over 100 columns to be changed.

I've looked into this on the RPD side but our aggregation rule sums the values and we are using an inner join so the ifnull is essentially ignored. We also would not want to create a new fact column in the RPD derived from these facts.

Your help with this is appreciated, thanks!

Answer 1

The easiest way is probably to set custom formatting on the column, in which you can format the display of null values. The other option, as you suggest, would be to edit each column of each analysis.

From the criteria of an Analysis, edit the column properties and set the data format of the column to a custom format with a mask of #,#.0;-#,#.0;0 (or #,0;-#,0;0 depending on your preference for precision).

You can then apply that formatting as the default for all columns with that source, or to all columns of that data type using the "Save as Default" option from the same dialog. For the former you will need to set the formatting once for each measure column you wish to affect.