NullToZero(), Nz()
Summary
Converts a null numeric value to zero.
Syntax
new_value = NullToZero(real old_value)
| Argument | Contents |
|---|---|
| old_value | The numeric value to convert |
Returns
A new value equal to old_value if old_value is not null, otherwise zero.
Notes
-
Can also be called as Nz().
Example
nullval = null
fixval1 = NullToZero(nullval) // fixval1 = 0See Also
| Function | Summary |
|---|---|
| ZeroToNull() | Converts a zero numeric value to null |