Jira Misc Custom field Calculated

AkashD March 13, 2017

Hello All,

I am sure anybody has achieved this tricky question please help me 

I am trying to calculate the value from three custom field 

example :-  Custom field = a   Custom Field = b custom field = c

what I am trying to do is 

if a != null and b != null  then multiply  and divide a+b/c   = custom field= d

So I have put a formula for Custom field d as below but it's not working 

any suggestion is highly appreciated.

<!-- @@Formula: ((Integer.parseInt(issue.get("customfield_a")) != null ? Integer.parseInt(issue.get("customfield_a")) : 0) * (Integer.parseInt(issue.get("customfield_b")) != null ? Integer.parseInt(issue.get("customfield_b")))/(Integer.parseInt(issue.get("customfield_c")) != null ? Integer.parseInt(issue.get("customfield_c")) : 0)--> 

 

1 answer

0 votes
Sten Sundelin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 14, 2017

Not sure about the syntax, but you have a 'divide by zero' issue if c == null or c == 0.

AkashD March 14, 2017

Hello Sten , 

Thanks for the reply but sorry i didn't get you 

Sten Sundelin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 14, 2017

If c is NULL or c is zero, you're effectively trying to calculate (a*b)/0 , which is mathematically undefined. 

I also think your formula is incorrect where it says "a+b/c" as your code seems to say "a*b/c" ?

I can't tell if your syntax is otherwise correct or not, sorry.

Suggest an answer

Log in or Sign up to answer