Calculating dates and retreating days

[Junaid Shah]

Hi,

I want to calculate a performance index based on dates.

I want something like this:

PFI = (Delivery Date - Project Start Date) / (Revised Delivery Date - Project Date)

if PFI > 1

"Ahead of schedule"

else if PFI < 1

"Behind schedule"

Right now I've got a scripted field in JIRA 6.0 and I was thinking running a script there, but perhaps theres a different/better way of doing this?

Thanks

[JamieA]

Creating a scripted field that does that simple calculation is fine, IMHO, given that all those inputs are properties (ie custom fields) of the particular issue?

If they are not then it's not so straightforward.

The alternative is using the expression function in Script Runner (other plugins are available). But you would need two queries, one to find things ahead of, and another to find things behind schedule. So you would put the conditional part of it inside the query.

[Junaid Shah]

Yes those are the fields of the issue that Im trying to calculate on, do you have any pointers on how I can go about coding this. I'm not a experience javascript guy and not sure what type of built in functions I can use with this ? Thanks.

[Junaid Shah]

Realistically what type of functions I can use to retrieve date fields in a type that i can manipulate to get the proper result