Calculation Values

  • PDInc
    Asked on March 11, 2020 at 11:53 AM
     
     

    Field 1. Multi Select field, I have 3 selections, and have Calculation Values turned on.  Each selection has a value of 1.  

    Field 2. I have a condition set where Field 1's value is copied to Field 2.

    If all 3 selections in Field 1 are chosen total number in Field 2 should be 3 not 111.  How do I fix this?

     

    Thanks!

     
     
  • Richie JotForm Support
    Replied on March 11, 2020 at 1:53 PM

    May we know the form in question so that we can check?

    It is possible to assign values to your fields.

    Guide:https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Then you can use the form calculation widget to calculate the fields.

    Guide:https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget


    Looking forward for your response.


  • PDInc
    Replied on March 11, 2020 at 2:20 PM
     

    See the last Section Collapse entitle "M.A.P."

    https://form.jotform.com/200703958575159


    Thanks!



     
  • Richie JotForm Support
    Replied on March 11, 2020 at 3:52 PM

    I have checked your form and it seems the condition for the field "Total Active Marketing Activities" calculation is using String, this is the reason why the values are not adding to the calculation.

    Calculation Values Image 1 Screenshot 30

    Kindly set the field to number by clicking on A-Z to change to number.

    Calculation Values Image 2 Screenshot 41

    Please give it a try and let us know if you need further assistance.


  • PDInc
    Replied on March 11, 2020 at 4:08 PM

    That did it.  Thanks!