Pages:
Actions
  • #1 by pcal72 on 18 Dec 2018
  • hello fellow

    I can not get rid of this problem, does anyone have an idea how I can get rid of it?

    I have a set of values, for example

    (3, -20, 23, 100)

    How do I know the second highest or second lowest?

    Thank you for your help

    PCAL
  • #2 by Oxa (WellDoneSoft) on 21 Dec 2018
  • Hi Pcal72,

    If the values are properties of selections, then you can make a trigger that sorts them by this property and picks the one with match_index=2, 3, etc.

    See the example attached for price difference over the last 1 minute.

    If it is a list of values, then there is currently no way I'm afraid.
  • #3 by pcal72 on 22 Dec 2018
  • Hi Oxa

    I forgot to mention, it is user variables 

    I can use MAXV( uservar1, uservar2, uservar3, uservar4.....

    But if I need a second most ?? 

    Is there any way to get this??

    Many thanks
  • #4 by Oxa (WellDoneSoft) on 17 Jan 2019
  • Sorry, can't think of any way to do this with just one formula.
Pages:
Actions