@CalcMgrIsFinite

Purpose:

Evaluates the specified member to determine if its value is finite. It returns false if the specified number is infinitely large in magnitude ( NaN or Infinity); otherwise, it returns true.

Syntax:

Java Class: com.hyperion.calcmgr.common.cdf.StringFunctions.isFinite(double)

CDF Spec: @CalcMgrIsFinite(doubleNumber)

Example:

In the following example, @CalcMgrIsFinite evaluates for the members in the FIX statement, to determine if its value is NaN or Infinity. If the value of "5800" is NaN or Infinity, it changes the value to #Missing.

FIX ("BaseData", FY13, Plan, Working, "111", @Relative(P_100,0)) 
    "5800" (
        IF (NOT @CalcMgrIsFinite("5800")) 
            "5800" = #Missing;
        ENDIF
    ) 
ENDFIX