How do I get a calculated custom field to display results in percentage?

Question

I have divided two custom fields (time spent / original estimate) and want the results in percentage.

I.e., the original estimate was 1 day, and we have spent 1.5 days, so we are 150% of the original estimate.

Here's the formula I used:

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

BMueller · Answer

Thanks, but I have a bigger problem - I can't get the calculated field to do what I want anyway, so it doesn't matter if it's in percentages or not.

I still want to display the results in percentage if I can ever get the math to work - but I don't think your propsed solution will work for me.

Thanks

Jobin Kuruvilla [Adaptavist] · Answer

https://studio.plugins.atlassian.com/wiki/display/GRV/Scripted+Fields is a good option to do things like this. Or create your own custom field and do this calculation in "view" template.