Validation of numbers in text grid

0

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%”

Edward90 answered
    0

    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:

    https://help.surveygizmo.com/help/continuous-sum

    Hope this helps!

    Dominic Sharpe answered
      0

       Thanks Dominic. 

      Edward90 answered
        ×

        Login

        Question stats

        • Active
        • Views479 times
        • Answers2 answers
        • Followers1 follower