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; } } }

Automation and formatting to 2 decimal places

Hi

I want to calculate the amount of time between certain workflow statuses and for the result to be in hours with 2 decimal places.

For testing I am taking the minutes since creation, dividing by 60 and putting this in a variable called hours:

{{#=}}{{now.diff(issue.created).minutes.abs}} / 60{{/}}

The variable is fine and prints to the log as {{hours}}

But I can't get the formatting to work. I tried {{hours.format("###.##")}} following the answer in this question but that produces no output at all. Any tips welcome, thanks!

Accepted answers

Hi @Julia Foden

I was able to do this with ROUND() so you could try:

{{#=}}ROUND({{now.diff(issue.created).minutes.abs}} / 60, 2){{/}}

Best regards,

Bill

All comments

Hi @Julia Foden

I was able to do this with ROUND() so you could try:

{{#=}}ROUND({{now.diff(issue.created).minutes.abs}} / 60, 2){{/}}

Best regards,

Bill

Hi Julia,

Maybe try to put the word issue in front:

{{issue.hours.format("###.##")}}

That's perfect Bill, thankyou very much!

I also tried this solution, but cannot get a custom created variable to format to display 2 decimals

Hi @Karen Kelly - did you see Bill's response above? Can you share what you have that is not working?

Hello @John Funk ,

Yes, the rounding works perfectly but if I want to display 2 decimals on e.g. 100 like 100.00 I can get t right using a custom field format e.g.

{{issue.customfield_xxx.format("##.00")}}

But not on my custom variable {{total}}

tried everything {{total.format("##.00")}} doesn't work and {{issue.total.format("##.00")}} neither

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

automation