Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The formula column type supports the following provides a convenient way to automatically calculate and display values in the table based on user-defined parameters. The values are calculated based on a preconfigured formula. The formula can be set up to use values from other numerical columns or select list columns.

Supported arithmetic operations:

  • addition “+”

  • subtraction “-”

  • multiplication “*”

  • division “/”

To create a formula, select Manage in the table Actions menu. Check the column types of the columns used in the formula beforehand. Valid column types are Number and Decimal number.

...

...

Index for search

By default formula values are not searchable via JQL. In order to see column data in issue search results, values should be stored in issue properties. This feature is enabled in ‘Manage Formula dialogue’ by marking the checkbox ‘Store value in the properties for the index search’.