Skip to Content

Sum of null fields in story?

May 18, 2017 at 03:26 PM


avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded

Hb - what is your data source?


Hi Hb, Were you able to figure this out?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Julian Jimenez
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.



10 |10000 characters needed characters left characters exceeded