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.

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

My screen shots do not appear to be showing. Maybe someone can share the magic trick for making those work as well.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    uBoatCaptain Make sure that when you click the "Photos" button ( I assume you are grabbing a snippet of the table or something that creates an image), select the image, and wait until the image loads in the preview pane... kinda weird upper right corner. THEN, click ok, if you do it prematurely the image won't load.

    As to the sum.. without the image it's hard to tell, but is the data type correct on the column?