get the largest negative value

  • Resolved arczil

    (@arczil)


    12 months ago

    Hello,

    What function should I use to get the largest negative value from fieldname, e.g.:

    fieldname1 = 34

    fieldname2 = 2

    fieldname3 = 0

    fieldname4 = -1

    fieldname5 = -5

    fieldname6 = -10

    calculated field should return “-1”

    • This topic was modified 12 months ago by arczil.
    • This topic was modified 12 months ago by arczil.
Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @arczil

    Thank you very much for using our plugin.

    You can implement the equation as follows:

    MAX([fieldname1, fieldname2, fieldname3, fieldname4, fieldname5, fieldname6].filter(n => n < 0))

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘get the largest negative value’ is closed to new replies.