AnsweredAssumed Answered

Functions Count(),List(),etc. with only one variable/constant - why no results?

Question asked by eworbit on Aug 7, 2017
Latest reply on Aug 10, 2017 by beverly

I feel like a noob for asking this.  Why doesn't List("justme") echo anything?

 

In data viewer, I get this error what trying to evaluate it:

 

"In the function Average, Count, Extend, GetRepetition, Max, Min, NPV, StDev, Sum, GetSummary or GetNthRecord, an expression was found where a field alone is needed."

 

Yeah, so what about List()??....

 

Some functions in FM can take a variables or constants even though the documentation heavily favors the word "field".

 

http://www.filemaker.com/help/12/fmp/html/func_ref1.31.4.html

 

List(field{;field...})

should be

List(field|variable{;field|variable...})

 

List("justme") - not valid

List("justme";"metoo") - valid

Count("justme")  - not valid

Count("justme";"metoo") - valid "2"

Count("justme";"") - valid "1"

Min("5") - not valid

Min("5";"6") - valid "5"

Min("5";"") - valid "5"

 

Is this just very old legacy stuff FM doesn't want to fix?

 

-Eric

Outcomes