Jira Misc Custom field Calculated

Question

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)-->

Sten Sundelin · Answer

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.

AkashD · Answer

Hello Sten ,

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

Sten Sundelin · Answer

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