Use of worklog (timespent) to calculate a field

Question

I would like to create a calculated custom field resulting of the next operation.

timespent (obtained from the worklog) * cost per minute (this is always the same = calculated custom field

The problem is that timespent is not a string field (although when you export it to csv is converted to seconds).

I hope to have explained myself properly

Thanks in advance

Iryna Prokop_SaaSJet_ · Answer

Hi @Luis

welcome to the Community.

As mentioned above, you can use Jira automation. Unfortunately, Jira is quite limited with this kind of math calculations. If you are ok with 3rd-party tools, I can recommend a project cost management app developed by my team.

Time and Cost Tracker automatically multiplies worklogs (hours) by the hourly rates to calculate the total labor expenses for each task/user, and sum these to get the overall labor costs.

Moreover, you can create reports and add expenses to manage project budget in general.

John Funk · Answer

Can you share the automation that you have so far?

Luis_i90tld · Answer

@Joseph Chung Yin and @John Funk Thank you for your welcome. I am willing to learn from such a helpful community.

I used {{issue.timeTracking.timeSpentSeconds}}*price per second to calculate the cost of manpower.

Later I wanted to calculate several costs with the same automation, some of them depending on the previous calculations. But I can not find the way of making the actions in the automations to follow an order.

I hope I have explained myself properly.