Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-16045

SO - Min/Max: Add "Zeros" to the Min/Max Caluclation

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Sprint:
      2021.R6 New Features Sprint 5, 2021.R6 New Features Sprint 6
    • SCRUM Team:
      Brotherhood of Mutants
    • Story Points:
      5
    • Work Type Classification:
      Sustaining

      Description

      Story

      As an admin, I would like the option to include "Zeros" in the order average when calculating the Min/Max for an item.

      Details

      "Zero" definition - In this case, the reference to zero in the average calculation refers to an occasion when an order is submitted to a vendor and an item provided by that vendor is unordered. For example:

      • The user creates an order for a vendor that sells 3 items: Lettuce, Tomatoes, and Onions.
      • The user submits the created order with the following details:
        • 3 units - Lettuce
        • 3 units - Tomatoes
        • 0 units - Onions

      If we were calculating an average for the last 5 "Onion" orders, this order example would count towards that average as "Zero".

      We also want to make this a user-selectable option.

      In MMS "Corporate > Admin > Corporate Rules Setup > Min/Max Rules" we need to add a selectable option to allow the user to include or exclude these zero values.

      The title of this option is "Include Zeros in Average". This should be a checkbox option below the "Standard Deviation" section in "Min/Max Rules".

      UI Details

      • Same vertical padding and spacing as the other options in the list
      • Checkbox left justified below the text entry boxes
        • Default state: Unchecked

      Wireframe

      Acceptance Criteria

      Confirm

      1. A new option in "Corporate > Admin > Corporate Rules Setup > Min/Max Rules" is available:
        1. Title: Include Zeros in Average
        2. A checkbox defaulted to unselected
      2. With the box Selected:
        1. The average for the number of orders in question is calculated including zero values
      3. With the box Unselected:
        1. Zero values are ignored and the average is calculated using only orders with non-zero values
      4. With the box either Selected or Unselected:
        1. The math for each average is correct and calculated based on the correct number of orders configured.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jason.powell Jason Powell
                Reporter:
                jason.powell Jason Powell
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 35.5h
                  35.5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 17h Time Not Required
                  17h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.