In SAS^® Markdown Optimization, metrics in the Markdown Approvals view might be incorrect when a list of plans, products, or locations is displayed at an aggregate level. When the Subset filter is Markdowns or Submitted and Approved, some columns display numeric values that are incorrectly calculated across all plan members. The calculations should include only the plan members that have markdowns in the selected period (week or month). The metrics in the Markdown Approvals view are correct when you display a list of product-locations that are the lowest level (uniform pricing level).

Columns NOT affected by this issue include the following:

• Plan Price
• Plan Eff Price
• Plan % Off
• Spend
• Affected Inv Units
• Affected Inv at Retail

Columns affected by this issue include the following:

• Plan Avg Price
• Plan Avg Eff Price
• Plan Avg % Off
• Plan Avg Eff % Off
• Markdowns Taken
• Markdowns Planned
• Season Sell-through
• Actual Sales Units
• Actual Revenue
• Actual Spend
• Avg Weekly Revenue
• Avg Weekly Sales Units
• Current Sell-through
• Current Price
• Last Reg Price
• Inv Units On-hand
• Oh-hand Inv Retail
• Inv Units On-order
• Avg Weeks of Supply
• End Sell-through
• Inv Value Retained
• Inv at Risk Units
• End Inv Units
• Est Sales Units
• Est Revenue
• Baseline Revenue
• Inv at Risk Reduction
• Inv at Risk Reduction / Spend
• Revenue Lift
• Revenue Lift / Spend
• Revenue Delay Cost
• Revenue Delay Cost / Spend
• Inv Delay Cost
• Inv Delay Cost / Spend

There are no errors or warnings.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Revenue Optimization 5.2 is available at: