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

  • Profile Image
    mrTore
    Asked on March 26, 2018 at 09: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?

  • Profile Image
    amy
    Answered 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.

  • Profile Image
    amy
    Answered 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

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

    1522078455form_calculation.gif

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

    1522078478form_calculation_2.gif

    I hope it helps. 

  • Profile Image
    mrTore
    Answered on April 05, 2018 at 05: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

  • Profile Image
    Scott
    Answered on April 05, 2018 at 08: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.1 

    And the calculation should be looking like this:

    1522930694Screen Shot 2018-04-05 at 15.1


    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!

  • Profile Image
    mrTore
    Answered on April 05, 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?

  • Profile Image
    Kevin_G
    Answered on April 05, 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. 

  • Profile Image
    mrTore
    Answered on April 06, 2018 at 08: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?

  • Profile Image
    Scott
    Answered on April 06, 2018 at 09: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.