I am collecting percentages in a grid.
For the example suppose its about percentage of types of fruit collected by month where rows are apple, pears, oranges etc. and columns are months: June, July, August etc.
Is there a simple way to check that each column adds to 100%.
Ideal would be a total percent row which auto updates to reach 100%. Otherwise simple error message “Response do not add up to 100%”
There is not a simple/built-in way to do this. In order to have a Textbox Grid output this calculation, a custom scripted solution would be needed.
SurveyGizmo has a Continuous Sum question that allows you to do this with a one-column layout – perhaps that might be a good workaround:
Hope this helps!