How to choose a max value?

  • Resolved mike1st

    (@mike1st)


    4 years, 11 months ago

    Hi there,

    for example, I have Field Type: Dropdown (fieldname5) with many Choices (value is numbers).
    I use “Allows to select multiple choices”.
    I don’t use “Merge selected options”.

    Then I have Field Type: Calculated Field, there I need to select the maximum value.
    MAX(fieldname5) is not work.

    How to choose a max value from Field Type: Dropdown (fieldname5)?
    Thx.

    • This topic was modified 4 years, 11 months ago by mike1st.
    • This topic was modified 4 years, 11 months ago by mike1st.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @mike1st

    That happens because the MAX operation requires the values to compare be separated parameters, and not an array.

    So, in your case you should to edit the equation as follows:

    
MAX.apply(null, fieldname5)

    and that’s all.
    Best regards.

    Thread Starter mike1st

    (@mike1st)

    It’s done!
    Thaks so much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to choose a max value?’ is closed to new replies.