Functions f(x)
What can Abacus do?
Abacus now has the ability to use Functions within its numeric formulas (Examples only pertain to Generic 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) |
Functions supported in Epic and Subtask Rollup formulas
Functions work a little different within Sub-Task Rollup to Issue and Issue Rollup to Epic. The formula represents function calculation of a single child field across all children rolled up to the parent.
| Function | Description |
|---|---|
| Sum | Add custom field from all child issues and populate result to parent. Sum (Field A) |
| Average | This will divide the overall sum of all child fields referenced by the number of child fields that exist and then populate the result to the parent. Average (Field A) |
| Mode | This will push the most common value from all child fields to the result field in the parent ticket. Mode (Field A) |
| Min | This will find the lowest value from all the child fields referenced in the and populate the result to the parent. Min (Field A) |
| Median | This will find the midpoint value between the highest number from the lowest number from the custom field on the child tickets then populate that result to the parent. Median (Field A) |
| Max | This will find the Highest value from all the child fields referenced in the and populate the result to the parent. Max (Field A) |