Power Users have the ability to edit calculated metrics such as the Inventory RTL or UNIT Need (+) or Overage (-) for 8 WOS metric found in the Inventory Opportunities Report.
Let's walk through the steps on how to update the amount of weeks from 8 to 6 for this metric!
How to Update and Rename a Calculated Metric
The Inventory Opportunities Report is located in the Dashboards folder within the Best Practice Reports folder.
💡Note: Only Power Users can complete the steps to edit a metric in Performance Analytics. To verify Power User status, check out this What is my User Type? Help Article.
Step | Instruction | Image |
1 | Right-click on the Inventory RTL or UNIT Need (+) or Overage (-) for 8 WOS metric and select Edit. | 
|
2 | Update the 8 in the calculation to the desired 6 amount of Weeks of Supply. | 
|
3 | Click on Validate to update the calculation.
Valid metric formula confirmation will appear. | 
|
4 | Rename the MetricUnder Display Name, scroll over to the 8 and update it to 6 to rename the metric column header name. | 
|
5 | Click Save. | 
|
6 | The Metric calculation and name have both been updated from 8 to 6 Weeks of Supply (WOS)! | 
|
How to Identify a Calculated Metric
In any report, you can identify a calculated metric under the REPORT OBJECTS folder where the Ruler Bookcase Icon has a "fx" on it.
Right-click on any of the "fx" metrics (Example: TY WTD Discount %), select Edit, and follow the same steps above to change the calculation of the metric.
⛑️ SPS Analytics Support
If you have any additional questions regarding SPS Analytics, please reach out to our Analytics Support team at:
☎️ 888-739-3232, Option 2