Forum Discussion

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

Qrew Legend

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

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
Qrew Legend
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
------------------------------