---
title: "Methods available to calculate aggregate results using DIVIDE function"
canonical: "https://support.appfire.com/space/SUPPORT/89150497/Methods%20available%20to%20calculate%20aggregate%20results%20using%20DIVIDE%20function"
format: markdown
---
This article explains the possible methods that can be used in calculating the aggregate results when using the DIVIDE function in a calculated expression.

## Instructions

Consider the example as Story points being divided by a number:

1. Login to Jira and navigate to *AIO Reports → My Area → My Reports.*  
<span style="color: #091e42">Note: Access to the app is controlled by the Access Permissions option, which is accessible only to a Jira administrator. </span><span style="color: #091e42">If the group they belong to is not selected, </span><span style="color: #091e42">users will not see the AIO Power BI menu item. In this case, the Jira administrator can perform the below steps:</span>
  1. <span style="color: #091e42">Click</span><span style="color: #091e42"> </span>*<span style="color: #091e42">Create New Field</span>**<span style="color: #091e42"> </span>*<span style="color: #091e42">to create a new calculated field.</span>
  2. From the right-hand side, search for the function *DIVIDE *and drag the function to build the expression:
    
  3. Now drag the *Story Points* field to the *value.*
  4. Input* 60 *as a* value**.*
  5. <span style="color: #091e42">Name the calculated field along with a description and validate the field and use it in reports</span>  
> Macro (inline-media-image)

  
  
<span style="color: #091e42">This method is called the ratio</span><span style="color: #172b4d"> of the sum, </span><span style="color: #172b4d">which is the app's default behavior. For example, if there are 2 issues i.e., issue1 has an SP value of 15 and issue2 has an SP value of 45, then the calculation according to the Ratio of the sum method would be </span>  
<span style="color: #172b4d">15/60 + 45/60. The result would be 1.</span>
  6. <span style="color: #091e42">Also, there is another way of calculating </span>*<span style="color: #091e42">Sum of ratios. </span>*<span style="color: #091e42">How does it work? Alright, the calculation will be performed as </span><span style="color: #172b4d">(15+45/60+60) i.e., wrapping the above expression with </span>*<span style="color: #172b4d">MULTIPLY</span>*<span style="color: #172b4d"> function. The end result would be 0.5.</span>  
> Macro (inline-media-image)


> ℹ️ - The usage of the methods depends on case to case. Preferably, the *ratio of the sum* would do the trick but in some cases, *Sum of ratios* works.
> ℹ️ - For more info on the Calculated fields, please refer [Calculated Fields - 6.5.7](https://appfire.atlassian.net/wiki/spaces/ART/pages/65503476)