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 time-indexed 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 fixed-rate 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 Black-Scholes. |
|
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 root-finding 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. |
| Is Empty | Will check if a value is empty. This is often used within an If/Then condition to check if a Model Point Field value exists and specify a value or behavior when the value is null. | |
 |
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 top-level menu again for ease of access. |
 |
Grouping | Create a grouping for mathematical precedence. |