Why can't I simply format a number field to consistently show numbers with 2 numbers after coma? why is that so hard? I have tried all kind of formatting options with no luck. issue. .format(".##") issue. .format("###,###.##") .format("###,###.##") .format(".##") I don't want to use script running or any APP it should be a simply and native task. But I'm wrong. Unless someone knows what I'm doing wrong.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Number field formatting

Rafael Ibanhez_020owy

Why can't I simply format a number field to consistently show numbers with 2 numbers after coma? why is that so hard?

I have tried all kind of formatting options with no luck.

issue.<field_number>.format(".##")

issue.<field_number>.format("###,###.##")

<field_number>.format("###,###.##")

<field_number>.format(".##")

I don't want to use script running or any APP it should be a simply and native task. But I'm wrong. Unless someone knows what I'm doing wrong.

Accepted answers

Bill Sheboy

Hi @Rafael Ibanhez

You appear to be asking about formatting a number with an automation rule. Is that correct?

If so, please try this:

{{issue.fieldName.format("0.00")}}

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Rafael Ibanhez

You appear to be asking about formatting a number with an automation rule. Is that correct?

If so, please try this:

{{issue.fieldName.format("0.00")}}

Kind regards,
Bill

Rafael Ibanhez_020owy

Hi Bill.

Using .format("0.00") instead of #.## helps with numbers after coma. Remaining problem is:

If I use .format("0.00") works fine until 999.99 following numbers won't have the thousands division, for example, 1,000,000.00 will show 1000000.00.

If I use the .format("0,000.00") then for numbers like 999 will show 0,999.00

Bill Sheboy

If you review that documentation, and the linked Java format reference, you can find how to combine these, such as with this:

{{issue.fieldName.asNumber.format("###,###,###.00")}}

Please adjust for a format as large as your numeric value can range.

Rafael Ibanhez_020owy

I feel dummy right now. That was the solution all along. Thanks for answering

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud