Forum Discussion

uBoatCaptain's avatar
uBoatCaptain
Icon for Helper I rankHelper I
9 years ago
Solved

Why is column not summing in a table?

  I have a column that is setup like in the image that is not summing. When I use it in a table it does not summarize by fund, and the table does not provide a total. The column seems proper...
  • DSimma's avatar
    DSimma
    9 years ago

    Check formats, If it is number stored as Text then it wont offer to Sum as Adding Text is unpossible. Make sure it is a number format. 

     

    The other thing I check first is to select the table and visualizations section make sure the values are not set to do not summarize when you click the down arrow beside them.

DSimma's avatar
DSimma
Icon for Advocate IV rankAdvocate IV
9 years ago

Check formats, If it is number stored as Text then it wont offer to Sum as Adding Text is unpossible. Make sure it is a number format. 

 

The other thing I check first is to select the table and visualizations section make sure the values are not set to do not summarize when you click the down arrow beside them.

uBoatCaptain's avatar
uBoatCaptain
Icon for Helper I rankHelper I
9 years ago

Thanks DSimma. It was the table visualization choosing a different summarization than is the default on the column.

 

Before I mark that as the solution, does anyone have an explanation why two columns that appear to have exactly the same properties on the Modeling ribbon pick up a different default when used in a table?