About

The Calculated Field is a custom field (implemented with Atlassian Forge) which allows you to perform automatic calculations on numerical fields.

Adding the field to the screens

1. Navigate to Issues > Custom Fields.
2. Locate the field named as Calculated Field (Stiltsoft).
   
3. Click [...] and select Associate to Screens.
   
4. Click Update.

Entering the formula or expression

1. The calculated field allows you to enter a formula or an expression to calculated numerical values.
2. Open the project where the calculated field is displayed.
3. Open the issue within this project.
4. Within the issue, locate the calculated field and hover over it.
5. Click the calculated field.
6. In the Edit calculated field form, enter the formula or expression.
   
7. When complete, click Save.

The field will calculate the values based on numerical values from other values. Use the field aliases from the Variable name column in your formulas and expression.

Quick recipes

Calculating the ICE score

1. Add the Impact, Confidence and Ease numerical field onto the issue layout.
2. In the calculated field, enter the following formula:

impact * confidence * ease

Calculating the RICE score

1. Add the Reach, Impact, Confidence and Ease numerical field onto the issue layout.
2. In the calculated field, enter the following formula:

const rice = reach * impact * confidence / efforts;
round(rice, 1);

Calculating the ratio of logged time to estimates

1. Ensure that the Original Estimate and Time Tracking fields are available in your screen layout.
2. In the calculated field, enter the following expression:

const timeDif = timetracking/originalestimate;
round(timeDif, 1);

Calculating the difference between estimates and logged time

1. Ensure that the Original Estimate and Time Tracking fields are available in your screen layout.
2. In the calculated field, enter the following expression:

const timeDif = originalestimate - timetracking;
dateFormat(timeDif);