Exclude data in formula

[#1]

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? 

GroupSquareWolf_0-1655911585163.png

[#2]

It might sometimes be a bit formula/function dependent but in this case adding Excluded() to grouping should work

jthi_0-1655912148378.png

Col Max(:Column 1, Excluded())

[#3]

Col Maximum( If( !Excluded(), :Column 1 ) )

Thank you for the hint. Got the code. 

[#4]

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

[#5]

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>)