Skip to Content
avatar image
Former Member

Sum of null fields in story?

Hi !!

I need help..

I am trying to totalize the columns and rows of a table, but the contents of the table depends on the filter that you select, some have null fields, is when you send me "Invalid_value" is there a way to solve this ??
Or is it possible to do this sum from the model ??
Thank you!!! picture1.png

picture1.png (137.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 23, 2017 at 09:12 PM

    Hi Hb,

    I can see that for some months the aggregation works as expected while in others you get the INVALID_VALUE.

    I can see a dash "-" in some cells. I believe that these fields were imported as text (Dimension) rather than measure (number).

    If you were using Excel, go back to the data modeling to transform those null values to 0.

    Cheers,

    Julian

    Add comment
    10|10000 characters needed characters exceeded