Formulas

Formulas in OneStream's Line Item Modeling solution are used to leverage Global Drivers, Lookup Drivers, and Cube Drivers to create meaningful and accurate calculations and develop driver-based operational plans. They can be applied to a wide range of data fields, from basic arithmetic operations to complex business calculations.

Formula Dashboard

This Use Case demonstrates the following situation:

  • Scenario: Build a set of formulas to determine if the federal tax amount still applies for an employee in a specific month.

  • Role: Implementer, Administrator

  • Benefits: Formulas can be individually created and the accounts applied to the formulas can be used as dependencies or building blocks for more advanced formulas to calculate more complex data.

See Workforce Planning FUTA Formula Use Case for more information.