The formula of the form calculation widget isn't working properly

  • mrTore
    Asked on March 26, 2018 at 9:04 AM

    hi im making a form with the gallery choice option, and i want to make a calculation with the values from the gallery multiplied with square meters in 6 different sections


    but i the sum doesnt come out rigth

    what migth i do wrong?

    is there a sum button i have to add?

  • amy
    Replied on March 26, 2018 at 11:24 AM

    I need some time to inspect it in detail. I will get back to you soon. Thank you for your patience.

  • amy
    Replied on March 26, 2018 at 11:35 AM

    It seems there is an unnecessary field in the formula of the form calculation widget. Please delete the "Price" field from the form calculation widget's formula and save it.

    1522078344Screen Shot 2018 03 26 at 18 2 Screenshot 10

    After this, your formula will be working properly. Before I delete the "Price" field, here is the result:

    1522078455form calculation Screenshot 21

    After I delete the "Price" field, here is the result:

    1522078478form calculation 2 Screenshot 32

    I hope it helps. 

  • mrTore
    Replied on April 5, 2018 at 5:58 AM

    Hi, im still having a problem With the price on this form. It is correct when i put in one multiple Choice. But when i put in every Field the price is not rigth.

     

    What can i do? I have put in the values in the multiple Choice gallery, which i want to multiply With the choosen square meters in the form for each content

     

    Glad for Your assistance

     

    Tore edland

  • Scott JotForm Developer
    Replied on April 5, 2018 at 8:20 AM

    Hey Tore,

    In order to achieve this, you can use show/hide conditions and provide the coefficient values of the services in the calculation field.

    Conditions may look something like this:

    1522930659Screen Shot 2018 04 05 at 15 Screenshot 10 

    And the calculation should be looking like this:

    1522930694Screen Shot 2018 04 05 at 15 Screenshot 21


    If you want to investigate this form, you can clone it to your account and test it for your self.

    Here is the user guide on how to clone a form from an URL


    Let us know if you need anything else,

    Cheers!

  • mrTore
    Replied on April 5, 2018 at 10:58 AM

    this was a little complicated for me to understand how to make in the form.

    is there tutorial on this function?

  • Kevin Support Team Lead
    Replied on April 5, 2018 at 12:01 PM

    Yes, you may check this guide to get more details about the show/hide conditions: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer 

    You may also clone my colleague's example on this link and inspect what he did there: http://www.jotformpro.com/form/80942828623968 

    The guide was shared on he previous reply as  well. 

    Please let us know if you need further assistance. 

  • mrTore
    Replied on April 6, 2018 at 8:21 AM

    hi again, ive added new calculations in the form, and added a rule witch i think is rigth


    ive changed the form abit so now there is  a gallery choise as before, but then only one input for square meters.

    my hope was to make it easier.


    but the math,calculation is still not rigth.

    am i missing someplace to make it active?

  • Scott JotForm Developer
    Replied on April 6, 2018 at 9:40 AM

    The conditions you have set are overriding the form calculation widget's values.

    Please disable/delete the conditions and the calculation should just work fine.