Hello Barb,
The field name in the list is a bit misleading, as it is actually calculated when it is displayed in an Adagio grid. You can create a calculated field with the following formula that will show the correct number:
Code:
({Qty on Hand 1} +
{Qty on Hand 2} +
{Qty on Hand 3} +
{Qty on Hand 4} +
{Qty on Hand 5}) -
{Qty Shipped not Cost}
You can copy and paste the formula from this post. Hope that helps.