Sign in to watch this episode
Episodes are free for Fabric Planning Community members.
Discounts shape how many units you sell, so a forecast should account for them. Parameters act as variables and live in the Parameters pane. We create a page-level number parameter called Product Discount, ID discount, shown as a percentage on a 0 to 25% slider in 0.5% steps and visible in read mode. Then we reconfigure the Units Forecast open period formula to Revenue Forecast / (Price Forecast * (1 - discount)). Move the slider and units rise with the discount.
Part of Planning · Season 2
