Jama's latest hosted release (2015‐02‐05) includes a much‐desired feature, Calculated Fields. This new functionality allows integer fields in an item to be calculated for sum, multiplication and average. Note that the calculation will accommodate for negative values as well as four decimal places.
Continue reading for a walk‐through of what the calculated field functionality looks like.
Level of Effort + Severity = Priority
1. Pick Lists should have integers assigned to their display values. In this example, Level of Effort and Severity are two pick list fields used in our Story item type.
Level of Effort
The functionality works on an individual item basis, so you cannot select fields from multiple items or item types. To create a calculated field, you will need to edit the item type and add a new field
. When you select Custom Field: Calculated, you will see many new options.
Option 4, Should all fields be required prior to calculating?
will control how and when the calculations occur.
With this box checked, all fields used in the calculation will need to contain a valid number before the calculation will occur. Note that this box is checked by default.
If the box is not checked, the following calculations will occur:
*If a field is null, it will be skipped in the calculation. For example, if you create a calculation type of Average that includes 3 fields, the null field will be ignored. If Field 1=10, Field 2=15 , and Field 3=null, the calculation will be (10+15)/2=12.5.
*If any field in the calculation contains an invalid value, the calculation will be rendered invalid and displayed as ‐
. This will happen if a value is non‐numeric.
For more on the February 7th release, watch the What's New
video on our blog.#requirementsmanagement