Forum Discussion
Columns not adding up correctly
Hi, Just looking for a bit of help regarding the addition of values in my table. I have uploaded all of my data from an excel sheet and when I put the data into tables the columns do not add up ...
Hi
Have you made sure to format the numbers as integers?
Hi, It is not numbers I am working with, for example if I have a list of all fruit it will count how many 'apples' are in my spreadsheet, so it is working with words rather than numbers.
Hi
In that case, go into the table. Under fields, select the little arrow next to the value and you can choose "Show value as" -> "Percent of grand total".
If it doesn't work with strings, you can add a column to your dataset with the count, so for each column of apple the value is 1. Then you can do the above, it works for sure with integers.
Let me know if this help.Please excuse the poor edit. Cannot post real data due to confidentiality :smileylol: