-
SueBurrowsAsked 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 ManagerReplied 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)
Let us know if you need more help.