Error in logs caused by Calculated Number Field

[Marc Jason Mutuc]

I'm using the following formula

<!-- @@Formula:

if (issue.get("customfield_17937").getTime() == null) return null;
if (issue.get("customfield_17938").getTime() == null) return null;
(issue.get("customfield_17937").getTime() - issue.get("customfield_17938").getTime()) / 1000 / 3600

-->

It shows on screen and all but my logs are full with the following message

IssueIndexer:thread-3 ERROR user001 395x16093x1 zbxffj 10.244.35.64,127.0.0.1 /secure/admin/IndexReIndex.jspa [innovalog.jmcf.fields.CalculatedNumberField] CalculatedNumberField: error evaluating formula: Sourced file: inline evaluation of: ``    if (issue.get("customfield_17826").getTime() == null) return null;  if (issu . . . ''

Tried using the following but the results are not shown on screen

<!-- @@Formula:

((issue.get("customfield_17937")==null ? null : (issue.get("customfield_17937").getTime()) - (issue.get("customfield_17938")==null ? null : (issue.get("customfield_17938").getTime())) / 1000 / 3600

-->

Please note that both custom fields are Date Time Fields.

[David _old account_ · Accepted solution]

You need to test the return value of issue.get(...) against null, not the return value of issue.get(...).getTime() :

<!-- @@Formula:
if (issue.get("customfield_17937") == null) return null;
if (issue.get("customfield_17938") == null) return null;
(issue.get("customfield_17937").getTime() - issue.get("customfield_17938").getTime()) / 1000 / 3600
-->

[Marc Jason Mutuc]

Thanks David! We are really happy with your add-on and are happier with your support! Thanks again!