Computed Data Variable

Computed Data Variables or CDVs are used to process data from External Data Variables to prepare it for use in various World Variables. They can also be used to specify constant values for use in World Variables.

These variables are specified in terms of a formula and can reference any External Data Variables in the formula text.

Computed Data Variables can also be selected during Sensitivity Analysis as the underlying Data Variable in a Data Variable Range.

Formula Functions:
The following functions are available for use in formulas:

"(" Opens an evaluation frame.

")" Closes an evaluation frame.

"+" Addition operator.

"-" Subtraction operator.

"*" Multiplication operator.

"/" Division operator.

"<" Less Than condition evaluator.

">" Greater Than condition evaluator.

"=" Equal To condition evaluator.

"IF(Condition, True_value, False_value )"
If Condition evaluates to true, returns True_value, else returns False_value.

"MIN( arg1, arg2 )"
Returns smaller of the two arguments.

"MAX( arg1, arg2 )"
Returns larger of the two arguments.

"SQRT( arg )"
Returns square root of a non-negative argument.

"POWER( arg1, arg2 )"
Returns the value of arg1 raised to a power specified by arg2.

"EXP( arg1 )"
Returns e raised to the power of arg1. The constant e equals 2.71828182845904, the base of the natural logarithm.

"LN( arg1 )"
Returns the natural logarithm of arg1.

"LOG10( arg1 )"
Returns the base 10 logarithm of arg1.

"DT_YRS"
Returns the difference in years between the current Valuation Date and the active World State.

"EDV( string_arg )"
Returns the current value of the External Data Variable identified by string_arg.

"CDV( string_arg )"
Returns the current value of the Computed Data Variable identified by string_arg.