Deprecation - Global Calculated Fields

We first launched Calculated Fields in August 2020 as part of the global configuration (“global Calculated Fields”) and the core functionality of JSU (“Calculated Field post-function”).

We value your feedback and strive to deliver a high-quality core product. Based on your feedback and an in-depth assessment, we decided to deprecate JSU's global Calculated FieldsWe apologize for any inconvenience this change might cause.

What you need to know

The Calculated Field post-functionwill remain as part of the core JSU functionality and is not affected by this announcement. The global Calculated Fields will be deprecated and no longer available after November 12, 2021.

How to migrate

You can transform your global Calculated Field into a Calculated Field post-function within JSU or use an alternative Marketplace app. Read more about the different options below.


Use cases and alternatives

The Calculated Field post-function is a workflow function that performs automated calculations after an issue transitions to a new status.

Its main difference from global Calculated Fields is that the calculations are performed as part of a workflow transition and are not recurring on any other issue field change. Read more about it on the dedicated documentation page.

Here is an example of the steps you can take to replace an existing global Calculated Fields configuration with Calculated Field post-function.


Use CaseRoll up the total story points of issues to your Epic

Step 1

Prepare to configure the Calculated Fields post-function


Option A

When creating a global Calculated Field, a custom field is automatically created under Jira custom fields.

If you want to utilize this already existing custom field to configure a Calculated Field post-function, you can delete the global calculated field without trashing the custom field by not checking the checkbox as shown.

Then, select this custom field as your result field in the configuration of the Calculated Field post-function following Step 2.


Option B

Otherwise, create a new Jira custom (number) field and give it a name. Assign your field to the project screens you want it to appear. This will be your result field for the calculation. Then, follow the instructions in Step 2  for the Calculated Field post-function.

Step 2 

Configure the Calculated Fields post-function


Go to your project's settings and select the "Workflows" tab from the left-side navigation.

Click on the edit button on the right, and select the transition you want your calculation to perform. For example, if you select the Start Progress transition, your field will be calculated once your issue is in the In Progress status.

Switch to the post-functions tab and click the button "Add post-function".

Select the Calculated Field post-function from the list of post-functions and click "Add"

Configure your calculation to perform within the same issue and input the formula using the functions and fields drop-downs to calculate the total Story Points of the issues under your Epic.

Add your post-function and publish your workflow to save your changes.

Go to your Epic, input Story Points to the issues under your Epic, transition your Epic to In Progress, and your field is calculated.

The calculation will be performed every time your Epic transitions to the In Progress status.


Precondition (optional)

Configure the Value Field precondition in your Calculated Field post-function to restrict it to a specific project and/or issue type.


Other Appfire alternatives

Not happy with Calculated Field post-function? No worries! Here is a list of other Appfire solutions available on Cloud that may better apply to your specific use cases:

Product nameFunctionalityExample use cases
Power Custom Fields

Power Custom Fields for Jira offers a suite of useful and configurable custom fields to help you extend the data inside Jira using predefined calculations.

Available Custom Fields:

  • Number Fields
    • Sum Of Story Points
    • Un-sized Issues
    • Number of Stories
    • Completed Story Points
    • Completed Issues By Percentage
  • User Picker Fields
    • Previous Assignee
    • Modified By
  • Text-Fields
    • Parent Field Value
    • Parent Status
    • Time in Previous Status

For more examples and information about the product, please check the documentation.


Do you have any questions or need support?
Reach out to the dedicated support desk for Power Apps.

Roll up the total story points of issues to your Epic

Step 1

Go to Jira Settings → Apps → Power Custom Fields and click Configuration.

On this page, enable the calculation of Sum Of Story Points custom field from the list.


Step 2

Now you can control on which screens the custom field will appear. Follow native Jira's steps to select which screens your custom field should be associated with: 

  1. Select  > Issues.
  2. Under FIELDS, click Custom fields.


Step 3

Find the Sum Of Story Points custom field and click  > Associate to Screens. Alternatively, you can click the field's contexts link and then click Screens > Associate this field to screens.


Step 4

Check the screens on which you want to display the custom field.

Go to your Epic, input Story Points to the issues under your Epic and the Sum Of Story Points custom field will be calculated automatically.

Reports & Timesheets for Jira

Being a powerful reporting tool with an intuitive interface, Reports & Timesheets for Jira helps you create custom reports and dashboards for daily use. It also provides calculated fields functionalities to help you get more meaningful data in your reports.

Supported functions:

  • Numeric functions
  • String functions
  • Date functions
  • Logical functions

For more examples and  information about the product, please check the documentation.


Do you have any questions or need support?
Reach out to the dedicated support desk for Bob Swift Apps.

Calculate the final price of a product after tax

This use case requires you to have created 2 custom fields (Starting Price, VAT(%)) in advance in order to configure the calculations.


Step 1

Go to My Area → My Calculated Fields from the top navigation menu and click on ‘Create New Field' button to open the create calculated field page. 



Step 2

Start by adding the ADD() function to the drag and drop area. Then, drag and drop your custom field for Starting price in the value1 area.

In the value2 area, drag and drop the MULTIPLY() function and fill out the value area with your Starting price. Drag and drop the DIVIDE() function as your multiplier1 and then fill out the value area with your VAT (%) custom field and the divisor area with a constant value 100.

Add a name and description to your calculated field and validate your calculation by clicking on the 'Validate' button. Then, save your field.



Step 3

Navigate to the top and click to create a 'New report'. Add a name to your report on the top right corner.

Drag and drop your calculated field to the Fields area together with any other fields you would like to have in your report.

For example, you can also add the Project name field and filter it only for your desired projects. 

Finally, click 'Run' to see your report.



Support

Do you have any questions or need support?

Feel free to contact our team by raising a ticket to the JSU support desk. We are happy to help!