The following formula types are available within the Formula Builder. This list is organized the same as the Formula Component Selector menu.
Variables 

Model Point Field 
Read a value from the model point file. The available fields to select can be defined in the Model Point File definition. 

Product Variable 
Read the value from another product variable or the same product variable at a different time index (if it is a timeindexed product variable). 

Portfolio Variable  Read the value from another portfolio variable or the same portfolio variable at a different time index.  
Company Variable  Read the value from another company variable or the same company variable at a different time index.  
System Variable 
Read the value from an available System Variable. 

Tables 

Data Tables 
Read the value from a Table Structure. You will specify which value column to be read and a formula source for each Index column from the table. 

Decrement Tables 
Read the value from a Decrement Table. You will specify a formula source for Age, Gender, and Duration. A formula must be specified for each of these even if you know the decrement table type you are planning to use does not use all three. For example, if you know you are not using any Select & Ultimate tables, the Duration formula can just be set to a constant value of 0. 

Scenario Table  Read the value from the Scenario Table. You can choose to either read a fixedrate from the yield curve or a variable rate index defined in the Economic Scenario definition. You must specify a value for the Currency to read from as well as specifying a duration for Fixed Rate values or the specific Variable Rate.  
Finance Functions 

Present Value  Calculates the present value of another variable using a specified interest discounting.  
Annuity Factor  Calculates an annuity factor based on the parameters specified.  
Internal Rate of Return  Calculates an Internal Rate of Return based on a starting balance and a series of cash flows.  
Option Price  Calculates the price of a call or put option using BlackScholes.  
More details of the Financial functions shown above can be found here.


Utility Functions 

Goal Seek  Performs a goal seek to solve for a starting value for the current variable value to result in a specific target value on another variable. The current variable must be part of the calculation dependency chain in order for the goal seek to succeed. The goal seek is performed using the secant method rootfinding algorithm.  
Rolling Value  Calculates a variable (Average, Min, Max, Median, Sum) over a rolling period of time. See Rolling Value Formula for more details.  
Data Convert  Convert one data type to another.  
Math Functions 

Aggregate Calculation  Aggregate Calculations are special functions that work on lists of variables such as min/max functions.  
Natural Log  Calculates the natural log of a value.  
Exponential  Calculates e raised to the power of a value.  
Rounding, Floor, Ceiling  Provides tools for rounding, floor, and ceiling calculations.  
Date Functions 

Date Diff  Calculates the number of complete days, months or years between two dates.  
Date Of  Returns the time t of a date.  
Date Part  Calculates the year, month, day or time t of a date.  
Other Functions 

IF Condition  Provides a structure for creating if/else statements for conditional logic during processing.  
Constant  A static value for use in formulas. The value can take on any valid data type supported by the system.  
Time Index  Time Index is a specific type of System Variable that returns the current projection period time index. It is included on the toplevel menu again for ease of access.  
Grouping  Create a grouping for mathematical precedence. 