cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Exclude data in formula

GroupSquareWolf
Level III

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

 

 

4 REPLIES 4
jthi
Super User


Re: Exclude data in formula

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())
-Jarmo
GroupSquareWolf
Level III


Re: Exclude data in formula

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

Thank you for the hint. Got the code. 

hogi
Level XII


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

jthi
Super User


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

-Jarmo