How do I separate fields with the Form Calculation Wizard?

  • SueBurrows
    Asked on March 16, 2017 at 10:44 AM

    Good morning,

    This may sound like a crazy question, but how do I separate fields, for example, in the AVG function of the Form Calculation widget? A comma from my keyboard doesn't seem to work, I just get a list of the numbers instead of the equation. When I look at your sample equations, you appear to be using a comma, but, even then, if I take one of your commas out in the equation and put one of my own in, it makes the equation not work. Where can I get the "magic comma" :) that works in the equations?  I'm so sorry if this is really simple and I'm just missing it. 

     

    Thanks for your help!

    -Jaime Marsman

  • David JotForm Support Manager
    Replied on March 16, 2017 at 1:08 PM

    No problem, we are glad to assist you. I think you are working with this form: https://www.jotform.com/70744588342968 

    To fix this, simply turn the comma from a string value to number value just by doing a left click on it, example:

    (Also, remove the extra space after the first comma)

    How do I separate fields with the Form Calculation Wizard? Image 1 Screenshot 20

    Let us know if you need more help.