ZeroToNull(), Zn()

Summary

Converts a zero numeric value to null.

Handling of epsilon changed in Version 5.0.

new_value = ZeroToNull(real old_value, real epsilon)

Argument	Contents
old_value	The numeric value to convert
epsilon	If not null, the allowable difference from zero

A new value equal to old_value if old_value is not zero or within epsilon of zero, otherwise null.

Can also be called as Zn().
If an epsilon value is used, values within +/- epsilon of zero are considered to be zero.
In Version 5.0, a missing epsilon value implies that only exact zeros will be converted to nulls. In previous versions, a missing epsilon value implied that any value would be converted to null.

testval = 0.001

fixval1 = ZeroToNull(testval, 0.01) // fixval1 = null
fixval2 = Zn(testval, ) // fixval2 = 0.001