Array listbox and... footers and calculation :(

Hi,
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: https://doc.4d.com/4Dv18/4D/18/LISTBOX-SET-FOOTER-CALCULATION.301-4505215.en.html

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.

Regards,
Nhat

1 Like

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