To get an idea of how the formula calculator can be used, please see the following example:
...
In this example the total cost should be calculated automatically based on the estimated costs and the sales tax. For that we use this formula: "Estimated costs"+"Estimated costs"*"Sales Tax"/100.
You can paste the formula, if you click on → manage. Use the validate button to check the syntax of your formula.
Operations:
Multiplication >> *
Division >> /
Addition >> +
Subtraction >> -
Brackets >> ()
...
Formula
...
The formula 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 “/”
Formula column configuration is quite straightforward.
Enter an arithmetic expression into the ‘Formula’ field. To pass validation column names must be quoted.
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’.