Forum Discussion
Table to show blank values when using sum
I have a table with columns/values from a few different tables, one of which is a sum of a value. I want this value to show when blank, but I can't seem to enable that option when "Sum of" is enabl...
Thanks for the reply,
For some reason this didn't yield the expected results,
I ended up doing a simple measure that solved the issue:
blank = sum(table[value])+0
I never said I wanted to sum the names, must be a missunderstanding, sorry if I was unclear somewhere.
Like I've said, if I don't select Sum I can see the "show item with no data", but I need to sum the values, and then the option disappears.
You can do it in three steps.
1) Select your table column where you have some numbers and blank values and click "Don't summarize"
2) Then you can select the same column again and activate additionl option "Show items with no data"
3) And then you can select "Sum" on the same column again and it will calculate SUM of the values and also keep the BLANK values.