Forum Discussion

uBoatCaptain's avatar
uBoatCaptain
Icon for Helper I rankHelper I
10 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
    10 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
10 years ago

Thanks for the tip on uploading images. Here they are (the drag and drop was not working yesterday).

This is the column set up on the modeling ribbon. Below that are two tables that should be giving the same summarized result. The one on the left uses a column that is derived from the column on the right. I ought to be able to have the column on the right summarize like the column on the left.