Forum Discussion
Helper IWhy is column not summing in a table?
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.
Helper IThanks 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.
Advocate IVCheck 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
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?