MIN function returning 0 instead of correct value on form

  • Masalamedia
    Asked on November 23, 2016 at 7: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.

    Jotform Thread 996818 Screenshot
  • jonathan
    Replied on November 23, 2016 at 9: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..

    MIN function returning 0 instead of correct value on form Image 1 Screenshot 20

    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.

     

     

  • jonathan
    Replied on November 23, 2016 at 9:15 PM

    Additional:

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

    Example:

    MIN function returning 0 instead of correct value on form Image 1 Screenshot 20

     

     

  • Masalamedia
    Replied on November 23, 2016 at 9: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.

  • jonathan
    Replied on November 23, 2016 at 9: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