Help with 'MAX' function

  • Profile Image
    ofCats
    Asked on July 08, 2021 at 04:32 PM

    Hello

    I am trying to use the MAX function but not having much success. I have a number of single choice fields which each have a numeric value assigned to them. I want to use the MAX function to return the highest value of the fields selected. I don't have a comma on the calculator pad so I'm typing this in. When I preview the survey I get a 0 for every possible option, broken up by the typed commas; then when I select any of the options it brings up it's numeric value again separated by commas. I've copied the formula given in the example and just swapped the field names to my own but I'm still getting all the commas and zeros in.

    This is the most intrinsic part of my form so any help would be appreciated!

    Many thanks

    Clare

  • Profile Image
    Lorenz_A
    Answered on July 08, 2021 at 11:01 PM

    Hi there,

    Please allow me some time to look into your form.

    I'll get back to you here very shortly.

  • Profile Image
    Lorenz_A
    Answered on July 08, 2021 at 11:12 PM

    Hi,

    I checked your max() calculation, and the comma is set as a string, kindly please set it as a number type instead.

    It should have a dark background instead of brown.

    See the image below.

    1625800266_60e7be4a93bf3_The Easiest Onl

    Here's a clone version of your form. https://form.jotform.com/211888935079977

    I hope this helps. Let us know if you need any further assistance.

  • Profile Image
    ofCats
    Answered on July 09, 2021 at 08:56 AM

    Many thanks!