Skip to Content
avatar image
Former Member

Web Intelligence null replace with 0

Hi,

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.

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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]

    Add comment
    10|10000 characters needed characters exceeded