Is there a way to truncate and not round a value in JIRA to 2 decimals?

Karen Kelly
Contributor
January 10, 2023

I am trying to with either automation or something find a way to truncate a value instead of rounding it off to 2 decimals.

 

E.g. 4.566 would round to 4.57

but I want the result to be 4.56

1 answer

1 accepted

0 votes
Answer accepted
Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 10, 2023

Hi @Karen Kelly 

I dont think that you can do anything out of the box. However you can try this app https://marketplace.atlassian.com/apps/1225290/custom-field-suite-powerful-custom-field-types-for-jira?hosting=cloud&tab=overview and see if it fits your needs. It has a custom field type of a decimal number. Read more on their documentation here.

You may also search the marketplace to find apps that fits your needs best.

Let me know if that helps!

Karen Kelly
Contributor
January 11, 2023

Thank you! That is a very useful plugin, but still seems to round instead of truncate. I managed to use the following solution:

 

e.g. 2.145 should be 12.14 in this case

So I use FLOOR(2.145 * 100) / 100

Alex Koxaras _Relational_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 11, 2023

Good to know!

Suggest an answer

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

Atlassian Community Events