A workspace administrator can create a line item subset to generate a list of line items. These can be from the same module or different modules in a model. 

You can use line item subsets to:

  • Narrow down a large list of line items to a smaller group.
  • Group calculations together from different modules.
  • Group line items from different modules into one list.

Workspace administrators can set line item subsets as a dimensions in any module in the same model. You can also use a line item subset as a picklist or perform calculations on the line item subset. 

If you use the COLLECT function in a module that includes a line item subset, COLLECT() pulls the line item values into the target module from the source modules.

Note: Line item subsets do not have list properties.

Use cases

Some use cases for line item subsets are:

  • Currency conversion.
  • To apply a percentage growth to last year's income statement.
  • To convert invoiced amounts to cash for cash-flow forecasting.

Parent line items in line item subsets

If you have a parent line item in a line item subset, but the subset only includes some of its children, the value of the parent is only calculated from the line items in the line item subset.

For example, the parent line item, Total Expenses, has the sum:

Salary + Bonus + Car Costs + Phone Costs + Medical Costs

However, the Expenses line item subset only contains the Total Expenses, Salary, Bonus, and Car Costs line items.

In modules where the line item subset Expenses is used as a dimension, Total Expenses is then calculated by:

Salary + Bonus + Car Costs

If none of the line items in the sum are included in the line item subset, Total Expenses appears as a leaf item in the line item subset.