Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2026-04-03
Create Formulas Using Calculation Engine

Create Formulas Using Calculation Engine

Have these permissions:
  • calculation_engine.settings.read
  • calculation_engine.settings.edit
Formulas combine formula components and other formulas to indicate how to calculate billable amounts.
  1. From the header, select
    More
    Company Settings
    .
  2. Under the
    Accounting
    section, click
    Calculation Engine
    . Select the
    Formulas
     tab.
  3. Click
    Create New
    .
    To duplicate an existing formula, click the formula that you want to duplicate, and select
    Duplicate
     from the
    Actions
    drop-down menu.
  4. Complete the fields.
    Option
    Description
    Formula Name
    Enter a name.
    Purpose of Formula
    Select a purpose to determine how this formula should be used when calculating billable amounts.
    Display Formula Result in Calculation Breakdown As
    How this value displays in the calculation breakdown. The value is stored as the numerical value in reporting regardless of your selection.
    Rounding Preference
    Determines the strategy to be used when rounding the result of the formula.
    • Banker's Rounding with Currency Precision
      : The system default rounding. Uses Round Half Even as the method up to the precision of the related currency.
    • Round Half Up
      : If the number after the desired rounding precision is 5 or more, round down.
    • Round Half Down
      : If the number after the desired rounding precision is 5 or less, round down.
    • Round Half Even
      : If the number after the desired rounding precision is 5, the precision number is rounded to the nearest even number.
    • Do Not Round
      : All decimal places are maintained.
    Rounding Precision
    Determines how many decimal places the result of this formula should be rounded. This option is available only if you selected one of the following
    Rounding Preference
     options:
    • Round Half Up
      .
    • Round Half Down
      .
    • Round Half Even
      .
    Build a Simple Formula
    The entered equation is always used during calculations when applied in another formula or formula group.
    Build a Conditional Formula
    The logic in a conditional formula enables you to define the equation that the system should used based on matching certain values or conditions. Multiple layers of conditions may be supported.
  5. Click
    Validate
     to verify your calculations are correct.
  6. Click
    Save
    .