Array listbox and... footers and calculation :(

I don’t know if it as to be considered as a bug or not. But it seems to be.

If you have in a footer a sum of the column, if you mask some rows, the sum is unchanged, ie displaying the sum of ALL rows and not only the displayed ones.

What can I do ?

In the documentation here:

Right below the table, it states:

Note that predefined calculations take all the values of the column into account, including those of any hidden rows. If you want to restrict a calculation to only visible rows, you must use the lk footer custom constant and perform a customized calculation.

Hope that helps.


1 Like

I just ask me why ? What is the logic to calculate also on what is hidden ?