Scenario:
In your Saved Search, the Cost column is showing the same value as the Total Cost column. This raises concern because these fields are meant to represent different metrics:
- Cost should reflect the average cost per item.
- Total Cost should represent the average cost multiplied by quantity.
Solution:
After reviewing the Saved Search configuration, we determined that the issue was caused by the summary type applied to the Cost field.
The Item: Average Cost field was set to use the Sum summary type. This caused the saved search to aggregate costs in a way that made the Cost column reflect a total value, not the intended per-unit average.
Resolution Steps:
- Edit the Saved Search.
- Locate the Item: Average Cost field in the Results tab.
- Change the Summary Type from Sum to Maximum.
- This allows the search to display the correct average cost per item, rather than aggregating it.
- Click Save & Run to apply the changes.
After this update, the Cost column correctly displays the average item cost and no longer duplicates the Total Cost column values.
-----
If you find this information useful, let us know by reacting or commenting on this post!
