Sub-form, set permissions to "Do Not Show", calculate formula doesn't work

Sub-form, set permissions to "Do Not Show", calculate formula doesn't work


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"?

      • Sticky Posts

      • Zoho CRM Plus in 2023: Let's rewind

        Hey everyone, There's something about December that makes us want to sit back and remember all the wonderful moments, as we get ready for the New Year, 2024! (Psst! We are also turning 10—yay!) This year, CRM Plus had a lot of wonderful updates, taking
      • The CX Workshops are back in 2023!

        Hello, can you see my screen? Can you hear me? This is a phrase we've all been saying more often than "good morning" over the last couple of years. Well, now it's time to re-connect in person. We're excited to invite you all to the CX Workshops we've
      • Refer Zoho CRM Plus to your friends and earn rewards!

        Hey everyone,   We'd like to thank you from the bottom of our hearts for continuing to be our esteemed customers. Now you have the opportunity to refer Zoho CRM Plus to your friends or family members who are looking for a suitable solution to enhance
      • Social in CRM Plus now supports TikTok, Instagram Stories and Reels, and YouTube Shorts

        Hey everyone,   We are excited to inform you that Social in CRM Plus now allows you to publish on TikTok! We've also updated it to let you create Instagram Stories and Reels, as well as YouTube Shorts. Here's a brief about the updates.  Publishing on
      • Unified telephony in Zoho CRM Plus

        In any business, managing calls with the prospects or customers is an integral part of a salesperson or a support agent's daily life. They have access to information about the customers within Zoho CRM, and they also use a suitable PBX service to communicate