Versions Compared

Key

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

Excerpt
hiddentrue

Create almost any numeric formula using mathematical expressions.

Table of Contents:

Table of Contents
maxLevel2
separatorbraces

Operators:

Child pages (Children Display)
excerptTypesimple


Requirements:

  • Create at least one field of type Text or Numeric to store the results.
Warning
titleCustom Fields
  • Abacus will not calculate empty Custom Fields because JIRA will send a null value for empty fields. We do not want to assume a value since everyone has a preference. For that reason, either use the Edit issue Action to set a field before calculating or set a default value for the field in your custom field configuration
  • Do not use Alpha characters as defaults values.

Generic Formula Image Modified

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

  1. Enter your custom formula name.

  2. Enter your mathematical formula. 

    1. Use an "@" symbol to utilize custom Numeric, Text, select, radio button, check boxes, 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 Formula" button saves the formula once you are finished editing it.

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

Image Removed
Expand
titleWatch generic formula tutorial video...
Align
aligncenter

Image Added

Widget Connector
width

889

400
urlhttps://

www

youtu.

youtube.com/watch?v=NNAEiAQKJXI&feature=youtu.beheight500

be/NNAEiAQKJXI
height400

Table of Contents
maxLevel2
separatorbraces


Child pages (Children Display)
excerptTypesimple

Increment FormulaImage Modified

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

  1. Enter your custom formula name.

  2. Select the Text or Numeric custom field you wish to Increment or Decrement.

  3. 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. Enter the value you want the field you wish to Increment or Decrement to start at. 

    2. Enter here the hard limit you want to set for the highest value the calculated field can reach.

    3. Enter here the hard limit you want to set for the lowest value the calculated field can reach.

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

Image Removed

Image Added

Note

If the custom field being referenced does not have a default value and the formula does not have a start value the calculation will not run

Note

If the custom field being referenced has a default value and the formula has a start value, the start value will be used during formula calculation

Expand
titleWatch increment formula tutorial video...
Alignaligncenter

Widget Connector
width

889

400
urlhttps://

www

youtu.

youtube.com/watch?v=

be/3RZCzGFbQtc
height

500

400





Align
aligncenter

Sub-Task Rollup to IssueImage Modified

Summation or averaging of numeric fields in Sub-Tasks and storage of the resulting value within parent ticket.

  1. Enter your custom formula name.

  2. Select the custom Sub-Task field you want to roll up into the parent issue.

  3. Select the mathematical function you want to perform on this field

    1. Either Summation or Averaging

  4. 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.

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

  6. Create an Execution Plan to run the formula

Image Removed
Expand
titleWatch sub-task rollup to issue formula tutorial video...

Image Added

Widget Connector
width

889

400
urlhttps://

www

youtu.

youtube.com/watch?v=

be/Uh5FE5VvcCs
height

500

400



Issue Rollup to EpicImage Modified

Summation or averaging of numeric fields in epically linked tickets and storage of the resulting value in the Epic.

  1. Enter your custom formula name.

  2. Select the custom issue field you want to roll up into the Epic issue.

  3. Select the mathematical function you want to perform on the field.

    1. Either Summation or Averaging.

  4. 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.

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

Note

An "Epic Link" field is required for the calculation to run on the child tickets.

Image Removed

Expand
titleWatch issue rollup to epic formula tutorial video...
Align
aligncenter


Image Added

Widget Connector
width

889

400
urlhttps://

www

youtu.

youtube.com/watch?v=rNi8tWvC6NAheight500

be/rNi8tWvC6NA



Insert excerpt
Date Formulas
Date Formulas
nopaneltrue

Warning

Custom Fields

  • Abacus will not calculate empty Custom Fields because JIRA will send a null value for empty fields. We do not want to assume a value since everyone has a preference. For that reason, either use the Edit issue Action to set a field before calculating or set a default value for the field in your custom field configuration

  • Do not use Alpha characters as defaults values.


Write into our Support Desk with any questions you have.