- gillesvdsAsked 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
- JotForm SupportKiranAnswered 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.
- gillesvdsAnswered on June 15, 2017 at 01:06 PM
- gillesvdsAnswered 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.
- JotForm SupportKevin_GAnswered on June 15, 2017 at 03:21 PM
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