# Form Calculations not adding the values correctly

• Kers101
Asked 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.

• Kers101
Answered on April 09, 2015 at 10:42 PM

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

• Charlie
Answered on April 10, 2015 at 03:48 AM

Hi,

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.

Kind regards.

• Kers101
Answered on April 10, 2015 at 12:16 PM

http://form.jotform.ca/form/43354089383259

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

Example here:

(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?

• Charlie
Answered on April 10, 2015 at 01:35 PM

Hi,

I believe that problem is the order of the values, this is an example:

Drop down list:

Option 1

Option 2

Option 3

Calculation Values:

1

2

3

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:

Calculation Values:

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.

Kind regards.

• Kers101
Answered on April 10, 2015 at 05:55 PM

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.

• Jan
Answered on April 10, 2015 at 07:58 PM

On behalf of Charlie, you're welcome. Let us know if you need any help.

Thank you.