Uploaded image for project: 'SR for Jira - Development'
  1. SR for Jira - Development
  2. SRJIRA-2084

Division in aggregateFunction doesn't work properly

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 4.3.7, 4.3.12
    • Fix Version/s: 4.1.3.23, 4.3.15
    • Component/s: JQL Functions
    • Labels:
      None
    • Sprint:
      Sprint 27 - Ends Nov 18
    • Critical Points:
      0.4

      Description

      JQL functions that divide a time sum by a time some don't work properly. For example:

      issueFunction in aggregateExpression(Original, "originalEstimate.sum()", Spent, "timeSpent.sum()", Remaining, "remainingEstimate.sum()", "Work ratio", "timeSpent.sum()/(originalEstimate.sum())*100d")
      

      The Work ratio will come back as 0.

      Code with a static number in the numerator seems to return what you'd expect:

      issueFunction in aggregateExpression(Original, "originalEstimate.sum()", Spent, "timeSpent.sum()", Remaining, "remainingEstimate.sum()", "Work ratio", "4000000000000000/(originalEstimate.sum())*100d")
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jcarter Jonny Carter
              Reporter:
              jcarter Jonny Carter
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: