Automation: error with math expression

Sarah Sheffield

Hi 

In an automation rule I use this expression to calculate the days an issue has been in progress (thank you to another community member who posted it):

{{#=}}ROUND({{issue.statuscategorychangedate.toDate.convertToTimeZone(reporter.timeZone).diff(now.convertToTimeZone(reporter.timeZone)).millis}} / (1000*60*60*24), 3){{/}}

In Jira Cloud it works perfectly.

But in Jira Server, I am getting this error every time I run it:

Error rendering smart-values when executing this rule:

Unknown unary operator '/' at position 7: ROUND(/(1000*60*60*24), 3)

How can the "/" division function be unknown?  I have tried replacing it with "divide" and that is also not recognised.

Any ideas from the hive mind?

Bill Sheboy

Hi @Sarah Sheffield 

That would seem to indicate that the field statuscategorychangedate is null, and so there is a typo perhaps.  The field is statusCategoryChangedDate

Kind regards,
Bill