The formula column type is used to implement calculation based columns. Supported are arithmetical calculation (+, *, -, /). Please note that data in formula columns is not searchable. To create a formula, click Manage:
...
Syntax: Column names should be quoted. Also its important to check the column types of the columns used in the formula. “Calculable” column types are: number and decimal number. Use the validate-button to check if your formula is syntactically correct.
...
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 “/”
...
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’.