Price for Jira tasks (and related reporting)

We sometimes have fixed prices for tasks. Is Jira (I guess with custom fields) capable of storing a task's price (where the currency can be of various types) and also do related reporting (e.g. sum of the prices of unresolved tasks for a project) kind of how it is with time tables?

Thank you in advance.

2 answers

1 accepted

1 vote
Accepted answer

You could leverage 2 or 3 custom fields

  1. AMount (number)
  2. Currency (select list)
  3. Reporting Amount (optional field, read-only, the value converted to standard reporting value)

Note that this is made a bit trickier for ondemand since not all plugins are supported.

If you weren't ondemand, I would suggest a plugin like Folio which is tailored to tracking portfolios with nice budgeting reports.

Currency conversion is tricky (accessing accurate converation rates and keeping up to date), but you could get pretty complex with a great free plugin, Script Runner, where you could handle the currency conversion of multiple types to a single reportable value. You can also use the aggregateExpression() function to get the sum using JQL.

But for ondemand you may use something like for custom reporting of all sorts, and I beleive allows custom values to be defined on the fly, eliminating the need for field #3. Ortherwise To calculate the "reporting value" (again noting the complex nature of concern, and maintaining accurate means to current rates, etc) you may be able to get clever with groovy via the included plugin JIRA Misc Workflow Extension-

Thank you Eddie, eazyBI looks like the perfect solution!

I agree Eddie! Gotta go with Folio.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,111 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you