Forum Discussion

ROBERTSTEVENS's avatar
ROBERTSTEVENS
Qrew Member
3 years ago

Test list to numeric for Min and Max functions

I was able to get a list of values in a list using: GetFieldValues(GetRecords("{23.EX.'"&[Related Event]&"'}", " "), 3) However, is there a way to get the MIN and MAX from the list if the result is...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
One would hope that these additional functions like MIN MAX would be rolled out "soon", but no word yet. Until then the only solutions would be a brute force parsing of the returned string into its parts assuming that the expected set retuned was some manageable number of entries like say 20 or maybe up to 50.  Post back if you need help with such a formula.



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
ROBERTSTEVENS's avatar
ROBERTSTEVENS
Qrew Member
3 years ago
Hi Mark,

Thanks for the help. MIN/MAX are available functions, however, they require numeric entries in the format of (1, 3, 7, 18, 4, 6). The problem is the list returned is a text list. I am trying to change the format so the MIN/MAX functions can be used.

------------------------------
ROBERT STEVENS
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    OK try this  (assuming that your formula query is correct)

    var text String = ToText(
    GetFieldValues(GetRecords("{23.EX.'"&[Related Event]&"'}", ""), 3));

    Max(
    ToNumber(Part($Value, 1, ";"),
    ToNumber(Part($Value, 2, ";"),
    ToNumber(Part($Value, 3, ";"),
    ToNumber(Part($Value, 4, ";"),
    etc

    ToNumber(Part($Value, 20, ";"))



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------