What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Form Calculations not adding the values correctlyAsked by Kers101 on April 09, 2015 at 09:33 PM
I have used values to correspond to options in the dropdown and also have made a list of choices made in order to check total.
List of values I set for a sample quote:
3" x 3" = 5
hand letter = 12
beach stone = 2
high gloss = 8
none = 0
Should add to 27 but form total is always 38 for this sample
Are you using calculation values on your drop down options? It seems like there are no values on them. You need to assign values, here's a guide on how to do it: http://www.jotform.com/help/301-How-to-Assign-Calculation-Value.
Here's a quick guide that you can also use as a reference:
1. In all your form fields, click the Properties and assign values on their calculation values option.
2. Fill out the "Calculation Values".
I see you have already setup the Form Calculation widget, that should fetch the correct values based on the calculation values that were setup.
Do let us know if you need more assistance on this.
I guess I forgot to save it
I re entered all the calculation values but the actual total for a sample stone still doesn't match the form total in #6
(Stone Size) 3"X3" = 5
(Appearance) both of above =24
(Stone Type) Smooth Slate= 5.25
(Stone Finish) Matt= 7
(Display Method) None =0
Total should be 41.25 What do you get for #6?
thanks for your help...
I believe that problem is the order of the values, this is an example:
Drop down list:
Unfortunately, some of the dropdown considers the "no option" selected as the first option, which makes it having a value of "1". Inshort, Option 1 will have the value of "2" instead. To solve this you'll need to add "0" in the Calculation Values to match the drop down option. So this should be setup like this:
0 - Refers to No option selected
1 - Refers to Option 1
2 - Refers to Option 2
3 - Refers to Option 3
Another problem is that in your #6 which is a Form Calculation widget, you are adding an extra "5" in your formula, based from the example you mentioned, the calculation field is just the sum of questions 1-5, is that right? See screenshot below:
I've cloned your form again and edited it, you can check it here: http://form.jotformpro.com/form/50995129292969. See if it calculates as expected, if it works good then you can clone it using this guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL.
I hope that helps.
It's been a while since I last worked on this file. I faintly remember that one has to put a zero at the beginning of the calculation values. It works great and now I don't have the extra 5.00 added on at the end. Thank you for your prompt clarification on this. Now we can refine the numbers a little more. I will be contacting you later when we start the payment protocol.
On behalf of Charlie, you're welcome. Let us know if you need any help.