Formula calculation

The detailed planning Formula calculation is used to create a simple formula.

The Formula calculation can combine literal values that you enter directly to the Formula box, along with operators and variable values. Variables can be attributes, existing calculations, or global vectors.

Operators are: add (+) subtract (-) divide (/) multiply (*) exponent (^) and unary negative (-).

 Note:  You are not required to use the drop-down lists—you can enter literal values directly from the keyboard.

 Example:  If you type [base salary] into the formula box, the calculation editor reads the square brackets and transforms your input to [BASE SALARY]. You can also paste content.

To validate the current state of a formula, click . The editor reviews the formula and if there are any syntax or other errors, specifies them, including the position in the line.

To clear the Formula box, click

Parameters

The drop-down lists contain the currently defined objects of their type in your detailed planning model.

After selecting, click Insert to add the variable at the current location of the cursor in the formula box.

Each type has its own appearance in the model, as follows:

  • Attribute: Square brackets: [BASE SALARY]
  • Calculation: Curly braces: {HOURS PER MONTH}
  • Global Vector: Angle brackets:<PAY PERIODS PER MONTH>

Examples

  • Calculate hourly expense rate:

    {HOURS PER MONTH} * [HOURLY RATE]

  • Apply a bonus percentage:

    {TOTAL SALARY TO OCTOBER} * 0.1

  • Calculate a benefit expense:

    {BENEFIT RATE} * {TOTAL SALARY EXPENSE}

  • Calculate hours per month:

    {HOURS PER WEEK} * <PAY PERIODS PER MONTH>