Use of worklog (timespent) to calculate a field

[Luis]

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

[Joseph Chung Yin]

@Luis -

Welcome to the community, as @John Funk stated, can you provide more information on how you created the calculated custom field?  So we can provide further assistance.

If you use automation rule, you should be able to use smart value of 

• {{worklog.timeSpentSeconds}}

to obtain the timespent in seconds, then take that value and converted into minutes.  Afterward you can multiple it with your costs per minute, and then populate your custom field.  

Hope this gives you an idea on getting your solution.

Best, Joseph Chung Yin

[Iryna Prokop_SaaSJet_]

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. 

[Luis]

@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.

[John Funk]

Hi Luis - Welcome to the Atlassian Community!

Have you created an automation rule to calculate this? If so, can you please share the rule?

[John Funk]

Can you share the automation that you have so far?