AnsweredAssumed Answered

Aggregate functions oddity (was List() function)

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

Let(

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:

 

Let([

$x = 3;

aList = List($x) ];

aList

)

 

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 16.0.1.162

Outcomes