- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Exclude data in formula
I found that when a row is Hide and Excluded, the data is still being used by a formula in another column.
Here is an example, Column2 formula is Col Maxium (:Coumn 1), row 4 is excluded and hidden, but the data is still being used by the formula in Column 2.
How to exclude data from row 4 so that it is not used by the formula in Column 2?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Exclude data in formula
It might sometimes be a bit formula/function dependent but in this case adding Excluded() to grouping should work
Col Max(:Column 1, Excluded())
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Exclude data in formula
Col Maximum( If( !Excluded(), :Column 1 ) )
Thank you for the hint. Got the code.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Exclude data in formula
Many thanks for highlighting this topic!
I also noticed it some while ago - and was surprised ...
Good that there is such an easy solution to get what you expect.
Does anybody know: Is the "exclude" neglected in the standard calculation due to speed reasons (no re-calculation with every change of the row "exclude" states)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Exclude data in formula
Not exactly the answer to @hogi's question but might be a good read related to this Col Functions and Row States . I think there has been some additional documentation related to this in release notes or in community, but I cannot find them now.
Also this might be helpful sometimes Col Stored Value(<dt>, col, <row>)