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)-->
Not sure about the syntax, but you have a 'divide by zero' issue if c == null or c == 0.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.