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) -->
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.