Organizations typically have a standardized approach to how they merchandise plan. For example, they might take Sales Retail 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 inverse calculations come to the rescue.
Let’s go over an example. Let’s say that we want to set Sales Retail for Apr to be $10M and want to set the Sales AUR as $100. To input Sales AUR, just right click on the metric name, and specify which metric you want to be calculated as an output, using the inverse relationship. You can then input $100 there and see Sales Units calculate. See below for how it works in action:
Saving the Output Metric to your View
You can change the configuration of what is an input and what is an output on your View. Just make sure to save the View after making the change.
If you want to configure the system so that Sales AUR is always an input and Sales Units always an output, that's also possible. Just reach out to our Customer Success team here and we'll take care of that for you.