I have modified the sub-form of the Quotes page layout to include a new calculated value based on a custom field from the Product records. We show the Year 2 price for support in our quotes...that value is set in the Product page. In quotes I have a formula to multiply the Year 2 value by the qty order to get a total

I only want to show the total amount (Year 2 X Qty). I do not want to show both the Year 2 unit value and the total.

When I set the permission of the Year 2 unit value column to "Do Not Show" the formula will still pass the Syntax check however when creating a quote or editing a quote the total value is not being calculated and shown in the Year 2 Total. It does work when both the columns are shown.

Do I have to show both columns? What is the point of "Do Not Show"?