How to ensure that total input value adds upto 100%?

  • Profile Image
    Asked on August 26, 2019 at 05:50 PM


    I am looking for way to phrase a question.

    We want to figure out how our clinicians spend their time, and we need to ensure that the numbers they input add up to 100%.

    Any tips you can give me?

  • Profile Image
    Answered on August 26, 2019 at 06:52 PM


    With my understanding of your question, I can see you wish to create a survey for your physicians and you need to understand a better way to do this. 

    You can try following our survey guides to help you create a perfect survey for your respondents. 

    A Guide to Creating the Perfect Survey Form - Part 1

    A Guide to Creating the Perfect Survey Form - Part 2

    How to create a survey form and customize it

    How to Create a Solid Customer Satisfaction Survey

    I am positive that these resources can help put you on the right track. 

    Please, let us know if you need further assistance and we will be happy to help.

    Thanks :-)

  • Profile Image
    Answered on August 26, 2019 at 07:43 PM
    No - can’t say this did help.
    Was hoping you might have an example where all numbers had to add up tp 100%.
    Thanks anyway
  • Profile Image
    Answered on August 26, 2019 at 09:31 PM

    You can use Form calculation to ensure that the inputs add to 100%. I can see from your form that you have added the Input table to capture this info and also set it to Numeric text box. 

    Your conditions also seem correct, except for a few changes. Please remove the last "=%" added in the condition below. This will ensure that the "Total" field has the correct value.


    Once this is done for all the four conditions, you'll get the correct Total value.

  • Profile Image
    Answered on August 26, 2019 at 09:43 PM
    Wow - thanks!
  • Profile Image
    Answered on August 31, 2019 at 09:43 AM
    After making these changes, users can still input numbers that either fall short of 100% or exceed it.
    Any thoughts?
    Thank you
  • Profile Image
    Answered on August 31, 2019 at 12:40 PM


    Apologies, but it seems we do not have any direct option to force input that would total to 100%. But, as a workaround, I can suggest to warn users that they have entered incorrect values. 

    Let's say, you can add a text element to your form (containing text of warning) and display it conditionally if total is not equal to 100. 

    Here is a screenshot: 

    To apply a condition, please check: How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    Also, it worth mentioning that conditions can not check input of a table cell, so you probably need to copy or calculate total in a hidden textfield or Form Calculation widget to build a condition based on it: How-to-Perform-Form-Calculation-Using-a-Widget