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

[Karen Kelly]

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

[Alex Koxaras _Relational_ · Accepted solution]

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]

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_]

Good to know!