Calculation Values

  • Profile Image
    aharrispdri
    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!

     
     
  • Profile Image
    Richie_P
    Answered on March 11, 2020 at 01: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.


  • Profile Image
    aharrispdri
    Answered on March 11, 2020 at 02:20 PM
     

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

    https://form.jotform.com/200703958575159


    Thanks!



     
  • Profile Image
    Richie_P
    Answered on March 11, 2020 at 03: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.

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

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


  • Profile Image
    aharrispdri
    Answered on March 11, 2020 at 04:08 PM

    That did it.  Thanks!