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
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good to know!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.