IsZero

Checks to see if the passed in value is close to zero based on a predefined Oracle Hyperion Financial Management epsilon. This function can be used in all types of rules.

This function is recommended instead of an exact comparison to zero where floating point arithmetic introduces errors of less than 1 x 10 E-10 that can be ignored.

Instead of:

Difference = Value1 – Value2 
If Difference = 0 Then
    'process where Difference = 0
Else
    'process where Difference <> 0
End If

Use:

Difference = Value1 – Value2 
If HS.IsZero(Difference) Then
    'process where Difference = 0
Else
    'process where Difference <> 0
End If

Syntax

BooleanValue = HS.IsZero(Value)

Return Value

A Boolean that is True if the passed in value is close to zero. False otherwise.

Example

Dim BoolVal 
Dim Value 
Value = 0.000000001 
BoolVal = HS.IsZero(Value) 
If BoolVal = true Then 
   'do processing 
Else 
   'do Processing 
End If