Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Caluculated sum of total count based on selected values

Nagaraju Reddy August 24, 2024

I have a field called "items" multiselect and values like (mouse, keyboard, monitor, phone)

when I selected Mouse the mapped amount is 2000 and keyboard=5000 and monitor-8000.

While creating a ticket it I selected items based on mapping "total purchase amout" field updated all items +

Mouse = 2000
Keyboard = 5000

Total Purchase amount = 7000.

I written a automation rule but getting error 

 

 

 


Screenshot 2024-08-24 at 6.33.44 PM.png

 

 

{{#=}} {{#if(issue.fields.customfield_10090.match(Monitor))}}3000{{else}}0{{/}} + {{#if(issue.fields.customfield_10090.match(Notebook))}}2000{{else}}0{{/}} + {{#if(issue.fields.customfield_10090.match(UPS))}}6000{{else}}0{{/}} + {{#if(issue.fields.customfield_10090.match(License))}}13000{{else}}0{{/}} + {{#if(issue.fields.customfield_10090.match(Add-on))}}15000{{else}}0{{/}} {{/}}

1 answer

0 votes
Ciara TN
Community Champion
September 2, 2024

Hi Nagaraju,

Can you paste in a screenshot of your automation please? 

And to ask also does this work if all options are checked, 1 option or 0 option? 


Thank you 

-Ciara 

Ciara TN
Community Champion
September 2, 2024

Also perhaps the LookUp Table function might be a better way to do this: 

Check out: https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Create-lookup-table/ 

Add you can add the default also by covered using: {{lookup_table.get(issue.customfield_10090)|0}}

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events