Repeater sum column with pagination

Dear friends!
I could not find an answer to this question. How can I sum all values in the repeater column when I use pagination? In the attached example, the sum applies only to the current page, not the entire repeater. I am asking for advice.summing numbers.rp (62.5 KB)

Hi!

I don’t know of a good way to do this; as you’ve found, you have access only to the values on the current page.

A hacky workaround would be to maintain a second, non-paged repeater with the same dataset. Note on this second one, you wouldn’t have to bother presenting any of the dataset on-screen. That is, the repeater row could be completely empty, without any “set text of row_rectangle to [[Item.value]]” code in its OnItemLoad handler, which would help with performance.

1 Like