I think your UDF approach was on the right track, but try:

SELECT SUM(line_total) FROM line_items ;
WHERE invoice_number=maintable.invoice_number ;
INTO ARRAY lajunk

Substitute "maintable" above with whatever table is driving the report.

--Brad