Calculations in Automations

[Henk Heijmink]

Hi all, I have 3 custom fields that contain numerical values. (say a, b and c) I want to set up an automation that is fills a 4th custom field with the value of a x b x c.

The values are actually a number that represent severity, probability and easy of detection for a specific bug. The multiplication of these number a x b x c will produce a number called RPN (Risk Priority Number) that will indicate the priority to work on fixing a bug.

It's a bit silly that we have to manually doc this calculation is any of the parameters change, so I was wondering if an automation is possible to do this?

I'm not so familiar with Jira yet, so your help is appreciated.
Thanks!

[Jack Brickey · Accepted solution]

Hi @Henk Heijmink ,

you can use automation smart values. Example below...

{{issue.CF1}} * {{issue.CF2}} * {{issue.CF3}}

You basically use the edit issue action and select your CF4 and set the value to the above expression.

[Henk Heijmink]

Thanks Jack! Very helpful!

[Fazila Ashraf · Accepted solution]

Hello @Henk Heijmink 

You can use the smart value math expressions -> https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/ in your automations.

[Henk Heijmink]

Thanks Fazila! Very helpful!

[Claas Babendererde]

{{#=}}{{issue.customfield_10091}}{{/}}{{issue.customfield_10090}}{{*}}{{issue.customfield_10081}}{{*}}{{issue.customfield_10092/100}}

Anyone got feedback to this calculation which leads to the error EINIGE FEHLER (some errors/non specified)?

1st. I set triggers

2nd. I added smart-value-variable {{totalscore}} (does not know if that is actually necessary)

3rd variable creation (total score field value) with the above posted calculation.

[Claas Babendererde]

Hey guys,

I really appreciate your q&a as it helps me with orchestrating a calculation on the score of tickets combining Foxly Score and other values like customer mrr, ticket views or ticket votes.

However, using smart values I am troubled with the #= expression, as there are no fields suggested.

Let's assume my ticket fields are "Upvoty Votes" with a numeric value, same as "Upvoty Views".

When I type down "{{x=" I thought there'd be a popup dropdown of all my available fields. However, I do not find a solution on how to express the different ticket fields that I have in the project.

Can somebody help?

[Marion Lepmets [SoftComply]]

Hi @Henk Heijmink,

In case you need a good overview of the risks in addition to their calculation, there is a number of risk apps for Jira available on Atlassian Marketplace that could come in handy.