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

    MIN function returning 0 instead of correct value on form

    Asked 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.

    Page URL:
    https://form.jotform.com/63277270303956

    Screenshot
    min function
  • Profile Image
    JotForm Support

    Answered by jonathan on November 23, 2016 at 09:13 PM

    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.

    Thanks.

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on November 23, 2016 at 09:15 PM

    Additional:

    For the MIN function to work, all the items must have answer first.

    Example:

     

     

  • Profile Image

    Answered by Masalamedia on November 23, 2016 at 09:31 PM

    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.

  • Profile Image
    JotForm Support

    Answered by jonathan on November 23, 2016 at 09:45 PM

    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.

    Cheers