Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 enabled. 

Is there any way around this? 

 

Thanks 

 

What happens now is I should see X number of projects in my table, but because some of them have a blank value here, I get less than expected rows/projects. I still want to see all of my rows even if this value is blank. 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hello, I think by doing this, it gives a number, but in my case it always return 0 for the list with empty value.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Try to right click on the Visual Field and check "Show Missing data".

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      That option goes away when using  "Sum" unfortunately. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Sorry, what is the "Sum of" column? is it a measure or a calculated column?

         

        Also the option is "Show item with no data" - should be visible for ProjectName and not for the Measure in the visual.