Use the SELECT function to return values from a given list item or time period.
For example, you can use the SELECT function to compare values between different versions.
Never combine SUM and SELECT in the same formula. Create two separate line items. One performing the SUM, and other using the SELECT to reference it.
Syntax
Source[SELECT: Target item]
Arguments
| Argument | Data type | Description |
| Source | Number, Boolean, date, time period, list, or text | The source module and line item to select a value from. This must be a module line item module.lineitem. |
| Target item | Time period, list | The item for the SELECT function to return the value from. This should be a List name.'list item' or Time.'time period'. |
The SELECT function returns a value of the same data type as the Source argument.
Calculation engine functionality differences
In Polaris, the reference in SELECT must be literal, rather than an expression, except you can use a literal offset from the current time period, Time.'Feb 23' + 1.
In the Classic Engine, SELECT can use expressions. The Classic Engine allows Time.'Current Period' in the expression for SELECT, but you can't use any other named Time period in expressions.
Syntax example
Income Statement.Sales[SELECT: Versions.Actual]
Additional information
We don't recommend the use of the SELECT function in conjunction with non-generic time periods. This use of SELECT goes against the sustainable nature of model building, where hard-coded elements can cause issues when updating the timescales of the model.
Use SUM or LOOKUP on modules with Time-formatted items, instead.
Excel equivalent
Examples
Example using lists
Example using time periods
Example using versions
