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.