Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,500
Community Members
 
Community Events
165
Community Groups

Automation rule for calculating fee for multiple currencies

Within our project, we have created an automation rule that calculates the 1.5% fee associated with running a campaign. This fee is calculated based on a field that takes a numerical value called Marketing Value. Currently, this field doesn’t handle non-numeric characters. The user must remove any $ signs and commas before they can submit the form.

The problem is that there is no default currency, so if the user removes the dollar sign or euro sign for example. Our team may think the sum is in USD.

Our current solution is to have another column to fill in the currency. Just wondering if there is a way that satisfies both requirements, which is having the Media budget field as a text field so the non-numeric characters don’t need to be stripped and we still be able to calculate the 1.5% fee from this field?

3 answers

0 votes
Ivan Lima Community Leader Jun 21, 2022

Assuming you're using Automation for Jira, you can try replaceAll by using something like {{issue.Marketing Value.replaceAll("([0-9])","")}}

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#replaceAll-String-regex--String-replacement-

Thank you for the swift reply.

 

I was wondering if there is a way to detect all non-numeric values in a text field, and then remove them from the text field. We will then use the syntax (value).asNumber to convert the value from text to number?

 

Thanks in advance for helping :) 

0 votes
Ivan Lima Community Leader Jun 19, 2022

If you cannot standardize to a particular currency, it would be easier to have something like "Marketing Value (USD)," I'd keep your field as a number rather than trying to manipulate the string. Although possible, I always find it tricky to predict and implement the rules to make them work properly. By keeping them separate, I believe you will have more control over further calculations you might need. And, of course, I'd also explore marketplace apps that would address that for you.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,110 views 34 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you