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
Hi Anonymous ,
Assume there are Type and Value columns in the table.
So for Value column, please select "Sum" ; And for Type column, select "Don't summarize" and "Show items with no data", as shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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])+0Hello, I think by doing this, it gives a number, but in my case it always return 0 for the list with empty value.