A Sum in the footer of a selection based listbox appears almost instantaneously, at least with up to 40k lines in the listbox.
Footer formulas are not implemented in an Entity selection listbox, so something like “items.Dlr_OnHand.sum()” can be used. However this is very slow comparatively.
I have tried several approaches, including indexing the field being summed, but do not get very good results. Before I start experimenting with a separate process or Worker to get the sum, does anyone know a way to tap into 4D’s amazing listbox sum speeds?