JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
MIN function returning 0 instead of correct value on formAsked by Masalamedia on November 23, 2016 at 07:13 PM
The MIN function here should be showing me the lowest rating for a series of services. No matter what I put in for ratings (1-5) the MIN function is returning a zero.
Can you please try first removing and adding back the calculation widget on your form https://form.jotform.com/63277270303956
The MIN formula should be like this..
I test this using a cloned form and it was working just fine.
You can test it here https://www.jotform.com/63277652776974
Let us know if still not resolve.
For the MIN function to work, all the items must have answer first.
The correct answer to my query, it turns out, is that the function returns 0 if some of the evaluated fields have not been answered.
That is how the MIN function work. All items in the array MIN() must all be filled first to get the answer/result.
Thank you for letting us know its working now.