Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

SUBTOTAL does not allow Function_num that "ignores hidden rows"

Completed
Request Demo

Hi,

I've been trying without luck to use the SUBTOTAL formula to exclude hidden rows as a useful way to check if my total in the tables of the Financial Statements matches with the total in the Primary File, although I got a error message saying that the Function_num that ignores hidden rows are not supported.

Is there another way to tackle this?

Thanks a lot in advance.

Pedro

1

Comments

6 comments

Date Votes
  • Official comment
    Isabel Messore

    Great news! A recent release has added some upgrades to our SUBTOTAL formula, notably that it now supports the hidden ell operators 101 thru 111. By default, this functionality is enabled though there are some caveats (listed below). New files or embedded tables will automatically upgrade to this formula version and any existing files (including copies) will be automatically upgraded to this formula version. Should you run into any scenarios where your formula is impacted by this change and not yet upgraded, you can reach out to your CSM or our Support team and they can assist in getting those migrated.

  • Courtnie Carver
    • Edited

    Hello Pedro, 

    We have had questions about this in the past which you can view here.

    The good news is that this enhancement has already been added to the future roadmap. No specific timeline to share as of yet, but it's a step in the right direction. We will get you added to the list of supporters for this feature and you will be updated with any progress/updates. 

    Thank you!

    1
  • Jennifer Flores

    Hi, since the SUBTOTAL formula is not currently an option,  is there another way to get the same end-result? 

    0
  • Pedro Andrade

    Hi Courtnie,

    Thank you for your prompt reply.

    I guess I've just come around a way to double check if there are hidden rows in the meantime we wait for the Subtotal enhancement.

    Yes, please add me to the list of supporters for this feature! ;)

    Regards,

    0
  • Pedro Andrade

    Dear Isabel Messore, thank you for your update.

    Although, it seems there is a bug on the recent release as I still get error messages when trying to use 109 code. I keep getting the "#VALUE" error message everytime.

    Please advise on how can I get support for this issue.

    Regards.

     

     

    0
  • Liz Walters

    Hi Pedro,

    Happy Friday! I am going to connect you with our Support team so that they can investigate this further. They'll likely ask to see a screenshot of the formula so they can help troubleshoot it. I've opened a ticket for you and our Support team should be reaching out to you shortly.

     

    0

Please sign in to leave a comment.