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