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; } } }

Automatic rule not working - sum/multiply between custom fields

Sara Valoti SK

Hi everyone!

I want to create an automatic rule for the following custom fields: aaa, bbb, ccc, ddd, eee, fff, ggg, hhh, iii, jjj).
The formula I would like to apply is as follows:
(aaa*bbb)+(ccc*ddd)+(eee*fff)+(ggg*hh)+(iii*jj).

My rule works for the first two elements: (aaa*bbb)+(ccc*ddd)
But it doesn't work if I include the remaining part.

{{#=}}{{issue.aaa}} * {{issue.bbb}}+{issue.ccc} * {{issue.ddd}}+{{issue.eee}} * {{issue.fff}}+{issue.ggg}} * {{issue.hhh}}+{issue.iii}} * {{issue.jjj}}{/}}

What is wrong with this formula?

Thank you in advance.

Accepted answers

Stevan Mandić

@Sara Valoti SK maybe you should try with parentheses ()

{{#=}} ({{issue.aaa}} * {{issue.bbb}}) +({{issue.ccc}}* {{issue.ddd}}) + .....{/}}

All comments

Stevan Mandić

@Sara Valoti SK maybe you should try with parentheses ()

{{#=}} ({{issue.aaa}} * {{issue.bbb}}) +({{issue.ccc}}* {{issue.ddd}}) + .....{/}}

Bill Sheboy

Hi @Sara Valoti SK

For a question like this, please post an image of your complete automation rule, images of any relevant actions / conditions / branches, an image of the audit log details showing the rule execution, and explain what is not working as expected. Those will provide context for the community to offer ideas. Thanks!

Until we see those...

What do you observe happening that leads you to believe the formula is not working?

What are the types of your fields: text, number, selection, etc.? The types of the fields will impact how they are referenced / used in math operations.

Kind regards,
Bill

Sara Valoti SK

Hi @Bill Sheboy,

after careful verification, I can say that my formula works once yes and once no.

I will describe the specific situation so that I can clarify the problems I am facing.

The formula I would like to make work is as follows:
{{#=}}{{issue.Quantity First Item}} * {{issue.CAD Price First Item}}
+{{issue.Quantity Second Item}} * {{issue.CAD Price Second Item}}
+{{issue.Quantity Third Item}} * {{issue.CAD Price Third Item}}
+{{issue.Quantity Fourth Item}} * {{issue.CAD Price Fourth Item}}
+{{issue.Quantity Fifth Item}} * {{issue.CAD Price Fifth Item}}{/}}

Sometimes it works, sometimes it doesn't. What could be the problem?

See the attached screenshots.
I hope they are helpful!
Thank you in advance for your time and help.

screenshot 1.jpg screenshot 2.jpg screenshot 3.jpg screenshot 4.jpg

Sara Valoti SK

Thanks @Stevan Mandić but unfortunately I think the problem is not that.

Bill Sheboy

Thanks for that information, and...

When you describe it does not work consistently, have you checked the following:

Are the types of the fields all numeric?
Do the fields all have numeric values?
Have you confirmed the smart values are correct for the fields? Please use this how-to article to do that: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/
When it "works" does the value match what you expect?
When it "does not work", what do you observe happening?

Stevan Mandić

@Sara Valoti SK

1. Field to monitor changes: some words are lowercase (in Edit Field expression everything is uppercase)

2. I have tested your expression (it works). The only case when it doesn't work is when one or more number fields are empty. So each number field needs to have Value (you can set default value for custom field: 0)

3. Since you create variable with math expression during your automation, there is no need to repeat expression in edit field action. The value in edit field action can be: {{TOTALEpreventivo}} but it will work your way either (it's just redundant).

Also, in your expression, instead of using {{issue.Quantità primo articolo}} you can use {{issue.customfield_xxxxx}} where xxxxx is the ID of your custom field. (This would possibly solve the problem with lowercase, uppercase and letters like À.

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