Sum of value from query repeater

Wappler General How To
#1

Hi,
sorry to keep asking dumb questions, but every step takes me hours/days and i still don’t find the answer :frowning:

I have a query returning a dataset of rows. One of the values is “InvoiceRowTotal”

I have multiple invoice rows.

I have a repeat setup. This shows all the invoice line items. At the bottom of the invoice I want to show an invoice total, which should be a sum of InvoiceRowTotal

Something like

Blockquote
{{sum(repeat1[0].RowTotal)}}

is there some simple way to get the total of that column for all the rows to show at the bottom?

thanks in advance

#4

i got this working in the end

SC_InvoiceDetailsSelect.data.InvoiceDetailsSelect.sum(‘RowTotal’)

1 Like