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

Copy remaining estimate and then convert into hours in Calculated field

James Graham_k8z1nt

Hi,

I am copying remaining estimate into another field during a workflow transition. However, the data that gets copied is in seconds. I would like to present it as hours in a calculated field. This is what I have so far:-

@Formula:
if (issue.get("customfield_13315")==null)
return null;
return (issue.get("customfield_13315"))/3600;-->

This isn't returning any value to the field.

Please help

Thanks

James

Accepted answers

All comments

Nic Brough -Adaptavist-

Remaining time on an issue is not a custom field, so I suspect your "get" commands are not getting the right thing.

Unless you have defined a custom field for it, in which case, start with a look at the type of field it is. Numeric? Holds number of days, hours or minutes?

James Graham_k8z1nt

Hi,

I am copying remaining estimate into a number field and then trying to use a custom field to convert back into hours. I can get the time in seconds but when I try to convert it into hours, I get nothing. Its quite frustrating.

Thanks

James

Nic Brough -Adaptavist-

Ok, I think it might be converting with the wrong variable types. Could you try these two lines as calculations and see what they do (on any issue that has a number in the seconds field)

return (issue.get("customfield_13315"));

return (issue.get("customfield_13315"))/1;

I know a divide by 1 looks a bit odd, but it's a test to see if it gives you an empty result instead of the same number you get from the other line, as it would show a conversion is going wrong!

James Graham_k8z1nt

HI Nic,

This line: return (issue.get("customfield_13315")); Returns 10,800 (The issue has 3H remaining).

This line: return (issue.get("customfield_13315"))/1; Returns nothing and as such the field is not visible on the form view.

Thanks

James

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server