Table of Contents

Difference

Description

The result of subtracting one number from another.

Calculation Editor

Options

Input Parameter Values Input Values
Only Rollup If Generic Criteria

Input

Operation Input Values Required
+ or - sign toggles when selected Column or Literal ✔
+ or - sign toggles when selected Column or Literal ✔

Remarks

  • If the difference calculation is used from the Design > Calculations window, you will need to manually the second operation to a - sign to ensure a difference calculation is being performed rather than a sum.
  • The Difference and Sum calculations are identical in nature and can be used interchangeably.

Example

  1. Input: Actual Amount (100), Budget Amount (90)
  2. Quick Calculations > Math > Difference
  3. Output: 10