What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    What separator between fields in the parenthesis of an AVG() function ?

    Asked by gillesvds on June 15, 2017 at 10:31 AM

    When I click on avg() or avgNoZero() function, they do not include any separator as shown in several examples I found. Between the fields I added, I tried the period (.), a comma (typing ,) and also no separator at all... No success.

    It seems your calculation tool do an "eval()" (if you're a developer, you will understand) of the formula's string. So, the comma seems to me the best candidate but it's absent from the little keyboard.

    Help welcome. Thanks,

    Gilles from France

     

    Page URL:
    https://form.jotformeu.com/71652172304348

  • Profile Image
    JotForm Support

    Answered by Kiran on June 15, 2017 at 12:40 PM

    You can use comma in order to separate the values in the function. However, if the comma is displayed in Grey color, it is considered as String and the function might not work. Please see the screenshot below:

    You can just click on the Grey colored comma to change it to black as other commas are displayed above that works with the function. 

    Please give it a try and let us know if you need any further assistance. We will be happy to help. 

     

  • Profile Image

    Answered by gillesvds on June 15, 2017 at 01:06 PM

    Thanks, it works, great !

    The average is correct.

    Then I would get an integer between 0 and 20... BUT, completing my calculation, the formula :

    round ( avgNoZero ( FIELD_1 , FIELD_2 ) * 20 )

    4

    will result in the following insane string :

    What's the matter ?

  • Profile Image

    Answered by gillesvds on June 15, 2017 at 01:08 PM

    Note that all the questions will have only one good answer with a value of 1. So the calculation to get a french typical evaluation between 0 and 20.

  • Profile Image
    JotForm Support

    Answered by Kevin_G on June 15, 2017 at 03:21 PM

    @gillesvds, 

    In order to properly assist you, I have moved your question to a different thread, we will assist you as soon as possible here: https://www.jotform.com/answers/1174805