nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation for numeric calculations

Tushar Khandelwal

I have 4 numeric custom fields

1. Total value

2. Total Alignment

3. Total Effort

4. Total Score

I have to multiply first 2 custom fields then divide its output by 3rd custom field and then put its total to 4th custom field.

For example - 4*6= 24 , 24/5 = 4.8 (That should be put into 4th custom field ) ( Value * Alignment / Effort = Total Score )

Note - At the end the total score is 4.8 so it should round off to 5.

Can anyone suggest how to create this automation or is there any app in Atlassian marketplace ?

Accepted answers

Marc -Devoteam-

Hi @Tushar Khandelwal

Welcome to the community.

This can be done with automation.

See https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

Example:

In the edit action set the value of the field Total Score to the following:

{{#=}}{{issue.Total value}} * {{issue.Total Alignment}} / {{issue.Total Effort}}{{/}}

All comments

Marc -Devoteam-

Hi @Tushar Khandelwal

Welcome to the community.

This can be done with automation.

See https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

Example:

In the edit action set the value of the field Total Score to the following:

{{#=}}{{issue.Total value}} * {{issue.Total Alignment}} / {{issue.Total Effort}}{{/}}

Bill Sheboy

Hi @Tushar Khandelwal -- Welcome to the Atlassian Community!

Adding to Marc's suggestion:

Using the information from the same link Marc provided, you may add the ROUND() function around the expression to use the desired precision. For example:

{{#=}}ROUND({{issue.Total value}} * {{issue.Total Alignment}} / {{issue.Total Effort}}, 0){{/}}

Also please note well:

Smart values are name, spacing, and case-sensitive, and often do not exactly match the names of the fields on the issue views. When an incorrect smart value is used, that will evaluate to null, often failing to work as expected.

To confirm you have the correct smart values (or custom field ID), please use this how-to article with your issue: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Kind regards,
Bill

Tushar Khandelwal

Thank you that worked

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud