Details
-
Task
-
Resolution: Completed
-
Medium
-
None
-
None
-
RP Sprint 93, RP Sprint 97
-
GxP
-
A
Description
Problem Statement
US and CA need an average run rate of product consumption. This field currently does not exists and needs to be created.
Calculation should be taking the last 3 months average of the "Shipment 445" key figure from IBP for the sku/country
UPDATE from 24AUG22
UDH table: pgs_udh_cdm.ibp_actuals
Fiedl to use: "adjusted_shipment_445" to aggregate at period / sku / country level before averaging for last 3 periods
Acceptance Criteria
- Calculation should be taking the last 3 months average of the "Shipment 445" key figure from IBP for the sku/country
- Field can be name "Product Run Rate (last 3 avg shipments)"
- Field is added to the SRD table and is hidden by default
Comment: Resultant figures to be rounded off. Add comments in the tool tips for the calculation of the run rate field
qTest: Test Execution
Attachments
Issue Links
- links to
-
TC-656 001_Navigation_Market Risks/Alerts
-
TC-657 002_ Market Risks/Alerts_Filter_Validation
-
TC-658 003__Market Risks/Alerts_Product Run Rate (last 3 avg shipments)_hidden
-
TC-659 004__Market Risks/Alerts_Product Run Rate (last 3 avg shipments)_available
-
TC-660 005__Market Risks/Alerts_Product Run Rate (last 3 avg shipments)_Available in gird