AnsweredAssumed Answered

Aggregate functions oddity (was List() function)

Question asked by user28656 on Jun 19, 2017
Latest reply on Jul 7, 2017 by user28656


aList = List(3;7) ; ValueCount ( aList )



Returns 2, as expected.


But I was surprised that assigning List(3) to aList produced an error message. I was expecting "1". If it was not an integer literal but a field, then ValueCount works as expected.


This complains about a missing field:



$x = 3;

aList = List($x) ];




So the question is, what is the best way to generate a list of arbitrary values without having to touch the database fields?


FileMaker Pro Advanced