Forum Discussion
- MarkShnier__YouQrew LegendOne 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
------------------------------- ROBERTSTEVENSQrew MemberHi 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__YouQrew LegendOK 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
------------------------------