NSC | Saved Search Cost Column Incorrectly Matching Total Cost Due to Summary Type Setting

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.