AnsweredAssumed Answered

Calcs within List() can improperly evaluate

Question asked by LaRetta_1 on Feb 2, 2010
Latest reply on Feb 10, 2010 by LaRetta_1

Summary

Calcs within List() can improperly evaluate

Description of the issue

 FileMaker Product(s) involved:Several versions.  This bug was first reported in May of 2007  Operating System(s) involved:Windows XP Professional 2002 SP2  Detail description of the issue:I came across this bug again and remembered it from this post:http://fmforums.com/forum/showtopic.php?tid/187238  Exact steps to reproduce the issue:Use the file attached in the referenced link  Expected Result:The Case() calculations within the List() function should evaluate as Null (default result) and instead it produces 0.  We thought the issue only happened when within Let() statements but it happens with List() regardless.  Actual Result:Produces 0 instead of null.  Exact text of any error message(s) that appeared:None Any additional configuration information/troubleshooting that is relevant to the issue:It breaks the same if using If().  The Case() will only properly evaluate and produce null if GetAsBoolean() is used (see file calculation examples) or you must end each Case() statement with default result of “” and explicitly force the false result..  Any workarounds that you have found:None Thanks to Mr. Vodka for finding and reporting this bug the first time.  It is too bad that it must be repeated 2 1/2 years later.  Hopefully something will be done about it.

Outcomes