Organizations typically have a standardized approach to how they merchandise plan. For example, they might take Sales $ and Sales Units as inputs and have Sales AUR automatically calculate. However, there are cases where you want to explicitly set Sales AUR (or another calculated metric) and have one of the inputs be treated as an output. That is when locking and inverse calculations come to the rescue. 

Let’s go over an example. Let’s say that we want to set Sales $ for Apr to be $10M and want to set the Sales AUR as $100. After setting Sales $, just lock it using right click on the metric name. This will lighten up Sales AUR, which makes it available as an input. You can then input $100 there and see Sales Units calculate.  See below for how it works in action:

Did this answer your question?