ForceZero ( NumExpression )
Forces a number calc field to display zero if is empty
Average rating: 4.4 (32 votes) Log in to vote
Abrazos Data Consulting, Inc.
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Useful where Fixed Number of Decimals cannot be used but zero is still necessary to avoid user confusion. Not all functions will return a zero--"Count" will but "Sum" won't.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.