Multiply via automation Time tracking (log work) field

Esteban Halabi

Hi everyone, first off let me thank you for your time reading this.

The following question is for Jira Software Cloud.

 

I'm trying to do a multiplication with an automation.

 

Context: I have a "client rate" field that captures the cost per hour for a specific client. Different clients have different rates.

 

Goal: When a user Logs Time on a ticket, that time should be multiplied by the client rate to give me a value of Actual cost (another custom field that we have)

 

So for example

Client Rate: 1500

Time logged = 30m

Actual cost = 750

 

I'm having issues achieving this with the automation, I keep getting errors.

 

 

As an additional detail, the time is being logged through Tempo. 

 

Hopefully you can assist  

Thank you all

Ste Wright

Hi @Esteban Halabi 

I find it easier to use variables on these occasions - the below rule:

• Calculates the time spent in seconds
• Turns this into hours/minutes (based on 2 decimal places)
• Then calculates the result

A few notes:

• The "Re-fetch issue data" actions help ensure the rule runs in order
• You can change the decimal points by editing the 2 after the comma, in the variable {{timelogged}}
• There is a shorter method with one less variable, you create {{timelogged}} using {{issue.timetracking.timeSpentSeconds.divide(3600)}}, but it kept rounding to the nearest hour for me, so I used two variable instead

---

• Trigger: Work Logged
  • For = All Operations
• Action: Create Variable
  • Name = seconds
  • Smart Value = {{issue.timespent}}
• Action: Re-fetch issue data
• Action: Create Variable
  • Name = timelogged
  • Smart Value = {{#=}}ROUND(({{seconds}} / 60 / 60),2){{/}}
• Action: Re-fetch issue data
• Action: Edit Issue
  • Field = Actual Cost
    • {{issue.Client Rate}} * {{timelogged}}

---

Let us know if this works for you!

Ste