3/31/22
Use miscellaneous functions to perform a range of calculations with your data.
| Title | Description |
|---|---|
| CODE | The CODE function returns a list item's code. |
| COLLECT | Use the COLLECT function in a module that includes a line item subset to pull the source line item values into the module. |
| CURRENTVERSION | The CURRENTVERSION function returns the value from another line item for the version that is set as Current in a model. |
| FINDITEM | The FINDITEM function searches for a text value within the names and codes of the items or time periods in a given list or Time respectively. If the FINDITEM function finds a match, it returns the corresponding list item or time period. |
| ITEM | When used with a list, the ITEM function returns the list item that applies to each cell. When used with Time, it returns the time period that applies to each cell. |
| NEXTVERSION | The NEXTVERSION function evaluates the given expression using the next version. |
| PARENT | The PARENT function returns the parent item of list items and time periods. |
| PREVIOUSVERSION | The PREVIOUSVERSION function evaluates the given expression using the previous version. |
| RANK | The RANK function evaluates a set of values and assigns sequential rankings starting at 1. |
| RANKCUMULATE | The RANKCUMULATE function ranks values and then cumulates values in order of the ranking. It can perform ranking separately across different groups. |
| VALUE | The VALUE function converts text values that represent numbers to numbers. |