Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

The Calculation Field allows you to perform a series of arithmetic computations to a set or a series of fields.

The example below shows on how you can sum up the amount field from a using the Form Grid.


Figure 1: Configuring and obtaining Obtaining the field Field ID from a Form Grid.

In the Calculation Field 's configuration, add in a new variable that will map it to the field set in the Form Grid earlier. Match the From Grid's ID and field ID into in the variable field ID, as shown below.


Figure 2: Configuring the calculation field.Calculation Field


Figure 3: Calculation field in action.Calculation Field in Action

Using JavaScript Math Object in Equation

The "Equation" setting of Calculation Field supports Javascript Math Object. For example, to find the max number among several fields in a form, you can use Math.max() in the "Equation". Image Added