How to extract Delivery progress as Numbers in a Custome field?

[sureshr]

When i want to export or use teh Delivery progress field, values are not fetched if i want to create the Calculated field by copying the Delivery progress and Delivery status .

[Ajay _view26_ · Accepted solution]

Hi @sureshr 

I don’t believe you can currently extract Delivery progress as a reusable/exportable numeric custom field natively. If you need the number outside JPD, you may need a workaround outside JPD rather than inside a calculated field.

[Himanshu Tiwary]

Hi @sureshr 

As @Ajay _view26_ Mentioned You cannot directly extract "Delivery Progress" as a reusable numeric field. It is mostly used as a calculated display field in JPD.
The best solution is to add a "Number" custom field and use automation to store the calculated value in the custom field.
This way, you can use it for exporting and other calculations.
Example 

Trigger: Issue updated
Condition: (optional) Delivery Status changed
Action: Edit issue -> set Number field

Example value:

{{#=}} ({{X Field}} / {{Y Fieldl}}) * 100 {{/}}

[Bill Sheboy]

Hi @sureshr 

Yes, and...to the suggestions from @Ajay _view26_ 

Delivery Progress is one of the many calculation type fields in JPD which are determined only for display in the UX.  When wants the calculated value for things like export, JQL searching, exporting, etc., a workaround is to:

• Add a custom number field
• Use an automation rule to attempt to recreate the calculated value and save in the field
• This may require multiple rules using different triggers to maintain the field's accuracy as other data changes.  For a related scenario, please see this article I wrote on synch / sum of fields using rules.

Please note well: while we can generally guess how Atlassian determines some of the values, others are a mystery and not defined in the help documentation.  Thus, experimentation may be required to get the values you want.

Kind regards,
Bill