|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

Subtotal Features

Terminée
Demande de démonstration
Associé à spreadsheet functions

Hello,

I am looking to solve a consistent issue we have on Workvia where hidden rows are still counted in sum/subtotal formulas. One solution would be for us to use Subtotal 109 excel formula as a check to only calculate visible rows, but Workiva doesn’t currently support this function. Is this something that is being developed? Not sure if others have reached out for this risk or if you have any best practice to prevent hidden rows being calculated?

2

Commentaires

3 commentaires

Date Votes
  • Commentaire officiel
    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.

  • Brandon Ehrecke

    Hi James!

    Thanks for providing this feedback! I'm not aware of this currently being worked on so I have gone ahead and submitted this as an idea to our product team to review. You will be updated with any progress. Anyone else passing by is encouraged to up vote or comment on this suggestion. Let us know if you have any additional questions. Thanks! 

    1
  • Caroline Wilson

    Hi both 

    I raised this with Workiva Support back in May 21.  A very useful function in Excel to help detect data in hidden rows.

    0

Vous devez vous connecter pour laisser un commentaire.