Forum Discussion

Qrew Member

4 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

ROBERTSTEVENS

Qrew Member

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

4 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
------------------------------