Supply Status - Run Rate field calculated (last 3 monhts average of shipment 445)

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