Create a calculated field showing a percentage

Question

Hi all, I would appreciate it of someone could help me here. I'm completely new to JIRA and have no background as a user. I'm sure what I'm asking is actually fairly simple but I cant get it to work.

Essentially I have two number fields and I want to create a third which shows a percentage of the two. So simply:

Formula.JPG

I have attempted this using a calculated number field and some "script":

@Formula: (issue.get("customFieldId=10427") ÷ issue.get("customFieldId=10007") : 0)–>

This has not worked and even if it had I'm not sure it would show a percentage anyway.

I understand I could use a scripted field which I have the add in to do but I don't know where to start with that.

Help much appreciated

Formula.JPG

Junaid Shah · Answer

I'd like to add that the answer I've done is only dividing two fields which contain numbers, if you want to do a percentage calculation then e.g You may calculate something like

double difference = w-x as double

double division = difference/w as double

double answer = division*100 as double

return answer

this for example will give you the difference between w and x in a percentage.

Alastair Batche · Answer

Hi Sy, that definitely gets values in the field so a step closed I'd say! Not a percentage though, will that have to be done through a scripted field as you have done below? I'll give that a shot

Junaid Shah · Answer

@Formula: (issue.get("customfield_10427") != null ? issue.get("customfield_10427") : 0) / (issue.get("customfield_10007") != null ? issue.get("customfield_10007") : 0) -->