Sign in to watch this episode
Episodes are free for Fabric Planning Community members.
A checkbox on its own does nothing. This episode puts one to work. We create Price Change as a Boolean checkbox visual measure, checked by default for every month. Then we edit Price Forecast and set Allow input to Based on formula, with Price Change != 0. Uncheck a cell and its price is greyed out and locked. Change a total and the spread skips the locked cell while the subtotals still average correctly.
Part of Planning · Season 2
