You should do this on server (php/asp..), sum and construct data, not at front side.

OK, here is a project solution – works for me. May need some more REGEX magic for theNOT type operators, and you need to add a numerical comparison in parallel to the regex for lt, le, gt, and ge, plus an array comparison for in, ni. Maybe there is a better way of doing the filter comparison , so please if anyone else is interested, they can add to this solution. It will certainly work fine with a searchToolbar, with the standard bw operator and more common character based comparisons. It also takes care of case sensitivity using the “i” option of the RegEx object.

Any improvements welcome, although performance is good, testing on 10.000 records the sum builds as fast as the underlying grid – no decernable delays.

Here goes. Relevant parts in bold/italic: