Methods available to calculate aggregate results using DIVIDE function

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.
   Note: Access to the app is controlled by the Access Permissions option, which is accessible only to a Jira administrator. If the group they belong to is not selected, users will not see the AIO Power BI menu item. In this case, the Jira administrator can perform the below steps:
   1. Click Create New Field to create a new calculated field.
   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. Name the calculated field along with a description and validate the field and use it in reports
      
      
      This method is called the ratio of the sum, 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 
      15/60 + 45/60. The result would be 1.
      
   6. Also, there is another way of calculating Sum of ratios. How does it work? Alright, the calculation will be performed as (15+45/60+60) i.e., wrapping the above expression with MULTIPLY function. The end result would be 0.5.