Variable Properties refer to all the options and property selections that are available on each variable. These can be accessed by editing a variable within the Model Development module and clicking on the Variable Properties & Documentation bar at the top of the editor pane.
Name – The name of the variable. This will be used to reference the variable in other places and as the name that appears in all output reports. Changing the name of a variable will not break references to the variables, but could impact Dashboard reports that are filtered by name.
Data Type – The data type the formula is expected to return. This is used to ensure that the formula is valid and returning the proper type of data. It is also used by other formulas to ensure that the variable is being used correctly based on the type of data it will return.
Display Precision – The display precision is used in some places in Slope to shorten the display of digits in reports and output. It does not affect how the variable is calculated in any way.
Model Point Aggregation Method (Product Variables Only) – The aggregation option determines how aggregation is performed when adding up or summarized data for a product across all model points. The following options are available:
- Sum – The value from this variable will be added across all model points in force to calculate a total product sum.
- Average – An average for the product will be calculated by adding the variable result value from all model points in force and dividing by the count of model points in force.
- First Value – A single value will be used that is equal to the first model point calculated. Note that this may not be the first model point in your model point file because the Slope Calculation Engine processes model points simultaneously. Therefore, the value taken will be whichever model point finished calculating first, which could be any model point in force at the current time period.
Array - Indicates that this is an array variable and allows you to select an array for the purpose of specifying different formulas for each value in the array.
Time Indexed? – Indicates if the variable is time-indexed or not. Time indexed variables must be referenced using a time value and are calculated at all time indexes during the projection. Non-time indexed variables are only calculated once at time 0.
Force Recalculation – Indicates if this variable will be recalculated at each time index, regardless of if it has been calculated at a previous time index (by projecting into the future or past).
Scales on Purchase or Sale (Asset Products Only) – Indicates if the resulting value should be scaled when the model point is purchased or sold during the investment management processing. In general, this should be checked for any variables that calculate a balance (Balance Sheet items) and left unchecked for anything that calculates a cash flow, rate, or income statement type item. This should also be left unchecked for any variables that are calculated Per Asset, meaning that it is normalized to a single asset (regardless of how many are actually in force).
Calculate Post Projection – Indicates if this variable will be calculated at the end of the projection run, once all other calculations have completed. This should be used to calculate summary or result variables that need to use future projected values, particularly on portfolio or company level variables that depend on product results.
Output Variable – Indicates if this variable is output to the reporting module during model execution. This should be left unchecked for intermediate calculations that do not need to be used for reporting and to help improve performance.
Always Calculated - To help improve performance, this setting should be unchecked to skip calculating this variable when it is not referenced by another variable.