Sum of null fields in story?

[former_member433400]

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

[TammyPowlas]

Hb - what is your data source?

[JohnL]

Hi Hb, Were you able to figure this out?

[julian_jimenez · Accepted solution]

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