FileMaker Pro Custom Functions

Hello,

Be carreful with this type of calculation using

Evaluate ( Max or Evaluate ( Min or Evaluate ( Sum (...)

The result will be "?" if you have 1001 values in your list

Agnès, France
May 25, 2011 3:27pm

Thanks, Agnès! You're correct. I wasn't able to locate any documentation of this limitation, and I'd like to know more about it. Can you point me to a reference?

Tom Fitch, Portland, Oregon
May 25, 2011 5:11pm

I have no reference for this, just the tests I did with Evaluate and calculations in FileMaker.
There is no problem, usually we use this calculation on small lists, until the day where. this is what happened to me.

to test :

Let ([

myList = Customlist ( 1 ; nbr ; "[n]" ) ;

it = Substitute( myList ; ¶ ; ";" ) ;
Su = Substitute( myList ; ¶ ; "+" )
];
Evaluate( "Sum(" & it & ")" ) // Limit nbr : 1000
& ¶ &
Evaluate( Su ) // limit nbr : 5238
)
Let ( $Count = 0 ;
Customlist ( 1 ; nbr ; "Let ([ $Count = $Count + [n] ]; """" )" ) & $Count ) // limit nbr : 500000

Agnès, France
May 26, 2011 1:35am

Interesting. Thanks again for the info.

Tom Fitch, Portland, Oregon
May 26, 2011 8:32am

It also doesn't work if you only have one item in the list. You need to do a check and append a "0" to the supplied list if there is only one item.

Bernard Cheang, Singapore
December 29, 2011 11:25pm