IsAlmostEqual

Checks to see if the passed in values are equal based on a predefined Oracle Hyperion Financial Management epsilon. This function can be used in all types of rules.

A difference of -0.0000000000001 to 0.0000000000001 is considered zero difference.

Syntax

BooleanValue = HS.IsAlmostEqual(Value1, Value2)

Return Value

A Boolean expression that is True if the passed in values are equal ; False if they are not equal.

Example

Dim BoolVal 

Dim Value1 

Dim Value2 

Value1 = 10.1299999999 

Value2 = 10.13 

BoolVal = HS.IsAlmostEqual(Value1, Value2) 

If BoolVal = true Then 

   'do processing 

Else 

   'do Processing 

End If