Remaining Estimate + Time Spent using automation

Question

Hi,

I am looking to create 2 custom fields which would be the following:

Estimate at Completion = Remaining Estimate + Time Spent/Logged

Variance = Estimate at Completion - Original Estimate

I've previously done this using JMCF at a previous employer but now trying to see if it can be done using automation?

Thanks

Former user · Answer

That's great @Marc -Devoteam- thank you that has worked now.. I was hoping the result could be to 2 decimals (currently no decimals). I've removed the .round to see if that helps but still the result has no decimals.. Sorry last hurdle hopefully and then we're good!!

Marc -Devoteam- · Answer

Hi @rob.jeal

I think the issue is that math functions rely on number fields, the time fields in Jira are probably not recognised as number fields in Jira.

So we might think differently.

{{#=}}{{issue.timetracking.remainingestimateSeconds.divide(3600).round}} + {{issue.fields.timetracking.timeSpentSeconds.divide(3600).round}}{{/}}

Former user · Answer

Thanks again @Marc -Devoteam- . I tried your expression and got the following in audit - Failed to get value for (issue.fields.timetracking.timeSpent): {{#=}}{{issue.fields.timetracking.remaining estimate}} +{{(issue.fields.timetracking.timeSpent)}}{{/}}

I removed the 2 normal brackets from the timeSpent part of the expression and am now getting the following:

Too many numbers or variables: +0m

I am guessing this relates to the timeSpent field as I only changed the remaining estimate, whereas when I added 2hrs to time spent I got the same "too many numbers or variables" message but "+2h" instead of "+0m" .

It is a custom "number" field I am trying to populate as couldn't find a more appropriate field type.