Skip to Content
avatar image
Former Member

Empty cells are displyed instead of 0

Hi All,

I have the some requirement.

I have multiple measure variables (each for different trends)

Sales - current 12 months

Sales - prev 12 months

Sales - curr YTD

Sales - prev YTD

Here I show them in a crosstab in my dashboard. For various rows I see null/blanks.

I tried defining '0' in Undefined box.

But, it still shows null values

My table looks as below

0

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 25, 2017 at 12:53 PM

    Hi,

    You can try setting from edit intial view--Display zero values option.

    Not sure if this work for Universe but you can take alook

    BR,

    Lakshmikanth Adharapurapu

    display-zero-values.png

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Venkat,

      Not sure if you have already performed the work around mentioned in the screen shot. In the intial edit intial view could you please set display of custom values to custom and try placing with zero value.

      I do not have universe connection, hence i could not replicate it, but i am attaching possible solution.

      If this does not work please put a screen print, wht you did and what is the result?

      BR,

      Lakshmikanth Adharapurapu

      null-zero-intialview.png