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.

in universe I tried defining '0' in Undefined box.

But, it still shows null values

My table looks as below

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Apr 25, 2017 at 09:14 AM

    Is that columns are measure..? and check the datatype.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 25, 2017 at 09:38 AM

    Yes those are the measures.

    Data Type is Numeric.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25, 2017 at 09:45 AM

    Is your data source a BEx query? If so please see https://archive.sap.com/discussions/thread/3195688

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 25, 2017 at 09:47 AM

    My data source is Universe.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25, 2017 at 09:59 AM

    Hi - if the data source is a universe then this question has been asked and answered before - please see https://answers.sap.com/questions/137034/sap-design-studio-null-values-replaced-by.html - for faster results, please search for your question

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25, 2017 at 12:50 PM

    Hello Venkat,

    I think you can achieve it by Right clicking your Universe data source edit intial view in the design studio, display Zero values setting to default/Without currenct or unit/empty cell/Custom.

    You can try this option.

    BR,

    Lakshmikanth

    Add comment
    10|10000 characters needed characters exceeded