Skip to Content

Web Intelligence null replace with 0

Mar 07, 2017 at 05:33 PM


avatar image
Former Member


I have a report I have run which is showing some 0 values however a number of cells are blank, can anyone give any tips as to how I can get the null values to display 0?

Also on the same report one of the categories down the left is also displaying blank value however I want this row to be named 'blank' so the people receiving the report know these figures link to the field being left blank.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mar 07, 2017 at 05:47 PM

for display 0 try like this.

=[your object]+0

else right click on column and format number and custom place 0 in all number format blocks.

for other use if-else condition.

=if(isnull([your object]) or ([your object]="")) then "blank" else [your object]

10 |10000 characters needed characters left characters exceeded