Numeric Formulas

Generic Formula is a free style formula type for numeric calculations. This format allows you to create calculations based on mathematical order of operations (PEDMAS or BODMAS) using fields from your Jira work items. Abacus also allows static values.

Create a simple or complex numeric formula using custom fields or static numbers.

1. Enter your custom formula name. (It will be titled ‘New Generic’ by default.)

2. Enter your mathematical formula. Type an "@" symbol to callout system or custom fields from your Jira instance. You can also create new fields if necessary from this section. These fields can be numeric, text, select, radio button, check boxes or multi select within your formula.

3. Select a result field for the calculation of your formula.

   1. The optional field allows you to round the result to the nearest whole number either up or down.

4. The "Save” button saves the formula once you are finished editing it.

5. Create an execution plan to run your formula based on a trigger. You can also add formula to an existing trigger. 
   
   

Open

Increment a field positively through addition or by a factor. Decrement through subtraction.

1. Enter your custom formula name. (It will be titled ‘Increment’ by default.)

2. Select the Text or Numeric custom field you wish to Increment or Decrement. You can also create new fields if necessary from this section.

3. In the Change Value textbox, enter the quantity you wish to increment or decrement by. This can be a positive or negative number.

   1. Examples (exclude the brackets) 

      1. Increment [ + 1.5 ]

      2. Increment by a factor [ * 1.5 ] 

      3. Decrement [ -1.5 ]

4. Show or hide the optional fields described below.

   1. Start at value: enter the value you want the field you wish to Increment or Decrement to start at. This can be used in the car when your result field does not have a pre-defined default value.

   2. Upper Limit: enter here the hard limit you want to set for the highest value the calculated field can reach.

   3. Lower Limit: enter here the hard limit you want to set for the lowest value the calculated field can reach.

5. Use the "Save" button to save the formula once you are finished editing it.

6. Create an execution plan to run your formula based on a trigger. You can also add formula to an existing trigger. 
   
   

Open

Note:

Summate, average, or execute a host of other math functions on a field across a work item’s child issues and store the resulting value within the parent work item.

1. Enter your custom formula name. (It will be ‘RollUp’ by default.)

2. Select the child issue type that the field to be rolled up resides within (Task, Sub-Task, Story, Bug, etc.)

3. Select the mathematical function (Sum, Average, Max, Median, Min, Mode, Sum, Range) you want to perform on this field across issues of the selected type from the previous step.

4. Select the parent issue type of the issue type that you selected in Step 2, and then select a result field for the calculation of your formula. You can also create new fields if necessary from this section. These fields can be numeric or text.

   1. The optional field allows you to round the result to the nearest whole number either up or down.

5. The "Save" button saves the formula once you are finished editing it.

6. Create an execution plan to run your formula based on a trigger. You can also add formula to an existing trigger. 

Open