Divide one Number field by another number field and add output to another field

[Vikrant Yadav]

Hi Friends, 

Hope you all are safe and in good health

I have one query, user is asking for calculation field,

would it be possible to add field to JIRA, containing formula/live calculation?

I have 2 number field Revenue and Time, user want to divide Revenue by Time and put the output in another field name "Profit". Is it possible, please help.

@Stephen_Wright  @Nic_Brough__Adaptavist_  @Kristian Walker (Adaptavist) @Adrian_Stephen @Derek_Fields @Ravi_Sagar__Adaptavist_ 

@Martin Bayer _MoroSystems_ s_r_o__ 

Thanks 

Vikrant Yadav

[Nic Brough -Adaptavist- · Accepted solution]

A bit more advanced than you need, but you can just drop the bit about following links - https://library.adaptavist.com/entity/calculate-the-sum-of-all-values-of-a-custom-field-in-linked-issues

[Martin Bayer _MoroSystems_ s_r_o__]

Vikrant, the documentation posted by @Nic Brough -Adaptavist-  should be enough, but if you're not programmer, here is a code you should use (I didn't test it so if there are any exceptions, let me know)

NOTE:  do not forget to fill in revenueCFId and timeCFId properties with real custom field IDs

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue

def customFieldManager = ComponentAccessor.customFieldManager
def revenueCFId = 111
def timeCFId = 222

def revenueCF = customFieldManager.getCustomFieldObject(revenueCFId)
if (!revenueCF) {
    log.debug ("Custom field with ID " + revenueCFId + " not found")
    return null
}

def timeCF = customFieldManager.getCustomFieldObject(timeCFId)
if (!timeCF) {
    log.debug ("Custom field with ID " + timeCFId + " not found")
    return null
}

def revenue = issue.getCustomFieldValue(revenueCF)
def time = issue.getCustomFieldValue(timeCF)

return revenue/time

[Vikrant Yadav]

Hi @Nic Brough -Adaptavist- @Martin Bayer _MoroSystems_ s_r_o__  Thanks you guys for the help. Script is working fine. Providing accurate result.

Thanks a lot :) ..you are the experts. 

Now user is asking to provide result in profit per hour, is it possible to calculate/convert time in hour ? Time field doesn't exists, day and time field is available only. Please suggest if there any solution of this.

Thanks Again!

Stay Safe!

[Nic Brough -Adaptavist-]

If you have a date or date/time field, you're going to need to come up with a rule to convert it into a length of time

[Vikrant Yadav]

Hi @Nic Brough -Adaptavist- @Martin Bayer _MoroSystems_ s_r_o__  is there any way to convert or calculate issue created date and resolved date into hours. 

Thanks

[Vikrant Yadav]

Hi @Nic Brough -Adaptavist-  how can i convert it into length of time ? Please suggest, is adaptivist library having any script related to this thing ?

Thanks

[Vikrant Yadav]

Hi @Nic Brough -Adaptavist- @Martin Bayer _MoroSystems_ s_r_o__  i want divide Revenue ( number field) by Logged Time field and put value in Profit. Please suggest 

[Martin Bayer _MoroSystems_ s_r_o__]

Hi, you can get logged time in seconds (I hope I remember unit correctly, but you can test it):

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue

def worklogManager = ComponentAccessor.worklogManager
def customFieldManager = ComponentAccessor.customFieldManager
def revenueCFId = 111

def revenueCF = customFieldManager.getCustomFieldObject(revenueCFId)
if (!revenueCF) {
    log.debug ("Custom field with ID " + revenueCFId + " not found")
    return null
}

def revenue = issue.getCustomFieldValue(revenueCF)

def worklogSeconds = worklogManager.getByIssue(issue)*.getTimeSpent().sum()

return revenue/worklogSeconds

[Vikrant Yadav]

Thanks @Martin Bayer _MoroSystems_ s_r_o__  it's working perfectly. :)

[Sangmesh]

Hello @Martin Bayer _MoroSystems_ s_r_o__

I am new to Jira, I always wonder where to write this code exactly.

Could you please help me understand where exactly I have to write this script to obtain the result.

Thanks,
Sangmesh

[Martin Bayer _MoroSystems_ s_r_o__]

Hi @Sangmesh , welcome on the community. Could you create new thread with Topic you want to discuss? You can mention me, so I receive notification.

This topic is about calulations with custom fields values, so let's keep it clean :) thank you