512366_en-US

liliconcom

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? 

 

 

Data Blending and CleanupRe: 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(

, col, ) 

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

Re: Exclude data in formula

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

Thank you for the hint. Got the code. 

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