topic Re: Exclude data in formula in Discussions

Exclude data in formula

GroupSquareWolf — Tue, 27 Jun 2023 21:14:38 GMT

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?

Re: Exclude data in formula

jthi — Wed, 22 Jun 2022 15:36:02 GMT

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

Col Max(:Column 1, Excluded())

Re: Exclude data in formula

GroupSquareWolf — Wed, 22 Jun 2022 15:53:46 GMT

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

Thank you for the hint. Got the code.

Re: Exclude data in formula

hogi — Thu, 23 Jun 2022 18:19:07 GMT

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

jthi — Thu, 23 Jun 2022 19:11:12 GMT

Not exactly the answer to @hogi's question but might be a good read related to this . 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>)