How to format functions when making Numeric Formulas.

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)