Automation and formatting to 2 decimal places

[Julia Foden]

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!

[Bill Sheboy · Accepted solution]

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

[Julia Foden]

That's perfect Bill, thankyou very much!

[John Funk]

Hi Julia,

Maybe try to put the word issue in front:

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

[Karen Kelly]

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

[John Funk]

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

[Karen Kelly]

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

[John Funk]

ah, it might be something related to how a variable handles values - meaning it might not be natively using it as a number. But that's beyond me. 

Maybe @Bill Sheboy can weigh in. 

[Bill Sheboy]

Hi @Karen Kelly 

Are you trying to change the stored value in the Total field or the output in some message, email, etc.?

If you are trying to change the stored value of Total, what you describe will only work if you have a text field.  If it is numeric, Jira will most likely truncate any trailing, zero digits.

Or...is this a created variable?  Sorry as I was unclear on you scenario.

Kind regards,
Bill

[Karen Kelly]

hello @Bill Sheboy ,

I created this custom variable as part of my automation, it is the sum of a few fields, I just want the output to how with 2 decimals instead of truncated. Referencing it in the summary of the issue

[Bill Sheboy]

Thanks for clarifying, Karen.

What I think is happening is created variables are always text type (at this time...) and so your variable needs to be converted to a number for the format() function to work.  (Format can also work with date/time types...which are really number behind the scenes.)

Please try this:

{{total.asNumber.format("##.00")}} 

[Karen Kelly]

Thank you! This is the perfect solution! I appreciate the feedback