JotForm User Guide / Form Calculations /

How to Assign Calculation Value

How to Assign Calculation Value

Calculation values are generally used for calculations. It represents the numerical value of an input field. This feature is only available in the following fields:

🔘 Multiple Choice Field (Checkbox)

🔘 Single Choice Field (Radio Button)

🔘 Dropdown Field

To assign calculation values on these fields, follow these steps:

1. Select the field on your form to highlight it then click the GEAR icon.

2. Go to the OPTIONS tab and toggle the USE CALCULATION VALUES option to ON.

3. Below that option will be a 2-column table showing all the options on the left and a corresponding blank column on the right. This is where you will type in the respective calculation values for each option.

You can either manually enter each calculation value per row or paste values copied on your clipboard in the calculation values as a whole like so:


Instead of typing in 10, 20, 30, and 40 per row, you can paste...

10

20

30

40

...in one go. And that's it - The changes are automatically saved.

NOTE: For the Dropdown Field, the first option must always be zero. This represents the first empty value of the Dropdown field.

Demo: https://www.jotform.com/43355144901955

Dropdown demo: https://www.jotform.com/60810099989975

Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Contact JotForm Support: https://www.jotform.com/contact/

Send Comment

101 Comments...

See all comments
  • wwicklund

    Help with quiz form. Only 6 of the questions values are adding to the total percentage? I have 15 questions but only 6 add up? What am I missing

  • CruzCarlos

    How to setup payment portion of the form to accept credit card payment based on selection

  • Kutler_Rachel

    Where do the calculations show up? When I go to analyze responses to the form, I don't see the values in the form responses.

  • Jonathan Krespil

    Hi how can I show calculated values on a form, I want the end user to see the information based on their selection

  • robert.bartlett

    is it possible to have the values accumulate for check out with the my products widget?

  • dennisjstone

    is there a way to have multiple answers to a question end up in separate cells in an excel report? e.g. which of the following are you interested in? a person choses three out of 5. could each one of these be in a separate cell for sorting purposes?

  • SeafoodLover

    Can I close the "empty option"
    I dont want the "empty option" to be in the dropbox list at all.

    can we do that?

  • nbsMobile

    Can you send emails on a scheduler on a drop-down, based on which person is selected? Li

  • Sportco

    How can I get the calculated result in the end?

  • glitzamor

    How do my customers see how much their balance is after entering calculated value?

  • bowercenter305

    Is there a way to add the calculation value from a single select to the amount due box within the Square Integration, rather that the customer having to make a selection AND enter the amount?

  • Tamk

    after adding the all option values the final calculation is inappropriate settled as per the template used, is there any way out where calculation will happen the way we want. Please share any video to help as demo...

  • BringitonSports

    Hello i can not find the add calculations field

  • MiavB

    Hi
    I'm struggling to access the options tab. It does not seem clickable. What am I doing wrong?

    Thanks

  • luxereloaded

    Hi,

    I am loving your software so far, thank you!

    I created a quiz, each correct answer has 1 point each.

    I am trying to get the points to add up and calculate the total of current answers when submitted. I am having problems doing this.

    Please help, it is quite urgent as this quiz is meant to go out tomorrow :(.

    Looking forward to hearing from you.

  • engagewisdom

    For a Select Multiple form entry, with calculation values assigned to each option, It appears that the calculation value is always the sum of the items selected. Is that the only option? Are other functions available, like the product of the selected values?

    And although I've added some negative numbers as values, it appears to sum the absolute value of the selected items. Is there any way to include negative values and get the true sum?

  • Anandu

    HOW CAN I SET THE TIME LIMIT FOR MY QUIZ. I need to automatically submit the quiz after 3 minutes..

  • Anandu D S

    I created a quiz containing 5 questions. And i assigned the point of. 10 to each question. But. It did not show any result of the quiz in submission.
    Please it is urgentt

  • alsharefa

    it doesnt show calculation value plz help

  • leoaccount

    My form seems to only partially calculate. 20 questions, 5 points each. I completed 18 correct yet the score shows 25.

  • asabah

    I've created a quiz with points for each question but i didn't get the total points in submission?

  • HandmadeWithLove78

    I need help with this feature! I have sent a few messages and would like to start using this form. Can you please look at at my from and see why i am unable to see the numbers and calculations on my form please

  • jmclark634

    I have a product discounted lines included in the drop-down that are listed:

    1. Buy 1 Get 1 half off
    2. Buy 6 take 30% off order
    3. Buy 12 items take 50% off order

    How to calculate this under calculations value?

    Thank you,
    Ja'Von

  • LaurenThompson

    I have multiple fields and wanted to know how you would get the online form ton provide a complete calculation at the end of a survey for example?

  • talk_enterprises

    This method does not bring up the $ symbol if instructions are followed.

  • FGOps

    How do I calculate the weight from pounds to kilos to grams?

  • khairi.khalid

    how to set if i need for example on Monday 1st week and 2nd week at 9 am only 2 persons available can book the form. Because now i just setting for a day not a specific time for available person can book. Thank you

  • dengel72

    In order to have these calculatable in a spreadsheet integration, having each option cost with its own column in the sheet would be great, or alternately some sort of multi-sheet setup. F/E, I have a list of options but when using Sheets integration, the values aren't in the spreadsheet. My homebrew solution is to keep those items separately in a second sheet, but it means double-work and a double-place to change manage.

  • teamhigher

    This is a great feature and very useful. I was hoping to use one of the widgets for a more stylish radio button, like "lined radio buttons" or "square radio buttons" but I see that none of those have an option for using calculation values. Am I missing something? or is there another way to add those values when using the widgets. I've tried all of the radio button widget types and none seem to have this option.

    thanks

  • pvillanuevab

    Cómo se hace para que aparezca el campo de abajo? el primero (el de arriba) ya complete los valores númericos de cada opción, la pregunta es cómo se hace para que aparezca el valor numérico de acuerdo a la elección realizada.

  • adebayostark123

    My Calculation values are not adding up its instead its just appending into numeric field e.g after clicking two options it results to "1,1" instead of two

  • Gary W Mussleman

    For shipping I am wanting to use the USPS "flat rate" service. The items being shipped are videos tapes, which means different sizes. Here is my reality:
    1 VHS = 3 VHS-C
    1 VHS = 6 Mini DV

    So there are basically three different sizes of tapes.

    There are 4 different flat rate boxes.
    Box A can hold 1 VHS
    Box B can hold 6 VHS
    Box C can hold 10 VHS
    Box D can hold 15 VHS

    If a person has a mixture of tape formats, I am wanting the form to be able to calculate which Biox is best for their shipping needs.

    Any way to do this.?

    Thanks in advance.


  • impactonmemphis

    How do I get the $ to show in price field?

  • fanlow

    Is it possible to set the assigned calculation values as subscription plans? If so, what are the steps to go about it?

  • markbrennanfitness

    When I paste a set of values to one single choice field, then paste another set of values to another single choice field, the FIRST single choice field updates to be the same as the SECOND.

  • STEMLab1

    Thank you this was helpful

  • YarraJFL

    how do i make the form make the choice unavailable once a certain amount of people have chosen this field.

    for example
    Choose
    check box AM
    Check box PM

    I want to close down the option to use "checkbox AM" once this box once 80 respondents have chosen

    can you please help

    how do i do this?

  • joelrtaub3939

    Very confusing to me. What I need instead of the field choice name showing up on a spread sheet down load, I just need a character, ie 1 to show up for each choice made. Can you show how to do this for a dummy?

  • joelrtaub3939

    I want a number 1 to be downloaded to my excel spreadsheet, so I tried to put a simple 2-1= that didn't work, tried to put a 1 value in but that didn't work either. What do I do?

  • TeamJOC

    Hello!

    We are trying to include a user supplied option so what value do we fill in the Calculation Values if we don’t know what it is. Is there something to fill in so it will pull the value from whatever our user enters?

  • werickson

    If the value of time in a date time field is between 8-5 I want "normal hours" auto selected in the next question, else "after hours" would be selected - how can I do that?

  • smartbizacademy

    Hi,
    i have to calculate "true" or "false" values by 33 questions
    at the end, i have sum the proper values (sometimes True = 1, sometimes False = 1 etc) (I have a table)

    how can i manage the calculations, pls?

  • VolACRS

    Where do I find the calculation results after I set them? I've used the form calculator field, tried to add up all the items that I included but nothing has shown there. Form can be seen here: https://form.jotform.com/83315515964158

  • BlueGiraffe

    No, I was talking about something else that I used once in my form.
    It is a calculator that allows to summarize the chosen options.
    For example if one class has been chosen, it is one price, if two classes have been marked, the double price appears automatically.
    Thank you!

  • Goodtimeboys

    How do I get this number to Multiply with another input?

    Eg/
    If I had one question asking how many items, then how do get it to multiply with another question which asks about price?

  • cvaughn

    How can I get the calculated value to show in an excel report?

  • musclebling

    It is not totaling is there something I can do?

  • vmghr2

    I created this form to submit the right answers after the test is complete it is no longer doing that please help me get the form back on track to make things a little easier in our hiring process

  • lifeisawesome

    I am trying to calculate results of multiple check boxes within each field (page) in for form calculation widget, but the final result is not showing properly. As a result, everything gets messed up. Kindly help.
    https://www.jotform.com/build/81262216518453

  • patwardhanmahesh

    Hi! Just wanted to know. How do we show calculation from numeric field values: I mean I have field1 and field2 and I want to show the result as field1/field2.