AnsweredAssumed Answered

Aggregate functions forcing calculation field to evaluate

Question asked by comment_1 on Aug 14, 2009
Latest reply on Dec 13, 2013 by philmodjunk

Summary

Aggregate functions forcing calculation field to evaluate

Description of the issue

A calculation field defined as = Min ( InputField ; 100 ) returns 100 when InputField is empty - even though the option 'Do not evaluate if al referenced fields are empty' is turned on.  I have no problem with the actual result returned by the function itself: Min ( "" ; 100 ) should return 100.But I don't understand why the calculation field evaluates, when the only referenced field is empty.  Workarounds: Min ( InputField + 0 ; 100 ) or: Case ( InputField ; Min ( InputField ; 100 ) ) 

Outcomes