Functions f(x)
How to format functions when making Numeric Formulas.
What can Abacus do?
Abacus has has the ability to use Math Functions within its numeric formulas.
Functions supported in Generic Formulas
Function | Description |
|---|---|
Sum | This will find the total value of all fields referenced within the function added together. Sum (Field A, Field B, Field C, Field D, Field E) |
Average | This will divide the overall sum of all fields referenced by the number of fields. Average (Field A, Field B, Field C, Field D, Field E) |
Mode | This will result in the most common number among all the fields referenced within the function. Mode (Field A, Field B, Field C, Field D, Field E) |
Min | This will find the lowest value from all the fields referenced in the function. Min (Field A, Field B, Field C, Field D, Field E) |
Median | This will find the midpoint value between the highest number from the lowest number in the set of data fields referenced in the function. Median (Field A, Field B, Field C, Field D, Field E) |
Max | This will find the highest value from all the fields referenced in the function. Max (Field A, Field B, Field C, Field D, Field E) |
Range | This will find the range between the lowest and highest value from all the fields referenced in the function. Range (Field A, Field B, Field C, Field D, Field E) |
Functions supported in Numeric Rollup formulas
Function | Description |
|---|---|
Sum | Add custom field values for Field A from all child issues and populate resulting sum to the parent. Sum (Field A) |
Average | This will divide the overall sum of all Field A values from child issues by the number of Field A values that exist for child issues and then populate the result to the parent. Average (Field A) |
Mode | This will push the most common value from all Field A values from child issues to a specified result field in the parent ticket. Mode (Field A) |
Min | This will find the lowest Field A value from all the child issues referenced in this formula and populate the result to the parent. Min (Field A) |
Median | This will find the midpoint between the highest value and the lowest value for Field A across the child tickets then populate that result to the parent. Median (Field A) |
Max | This will find the Highest Field A value from all the child issues referenced in this formula and populate the result to the parent. Max (Field A) |
Range | This will find the range between the lowest and highest Field A value for all the child issues referenced in this formula and populate the result to the parent. Range (Field A) |