LiveCode Forums.

I'm trying to calculate the total amount spent by a customer in my LiveCode database app. Here's the script I'm using:
on calculateTotalSpent (customerName)
local total := 0
repeat with aRow in orders where customer = customerName
put the amount of aRow into total
end repeat
return total
end ...