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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Sum - when you have values you can choose to have sum, average, min, max etc. or "Don't summarize", and it's only when it is on "Don't summarize" I can select "Show item with no data". 

      It's not a measure, just a regular decimal number column. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Exactly, Why would you summarize the Project Name in your visual? Maybe I m missing something. Can you share what columns are you showing in the Matrix/Table?

         

        If you do not summarize Project Name, then you can rightclick in the Fields visual and select "show item with no data".