Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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