Hellow Guys, I want to do SUM() for net amount and Group By tranid for the below query but when I try doing that, it gives me query error! can you please help me in it!

SELECT

BUILTIN_RESULT.TYPE_STRING("TRANSACTION".tranid) AS tranid,

BUILTIN_RESULT.TYPE_CURRENCY(BUILTIN.CONSOLIDATE(transactionLine.netamount, 'INCOME', 'NONE', 'DEFAULT', 0, 0, 'DEFAULT'), BUILTIN.CURRENCY(BUILTIN.CONSOLIDATE(transactionLine.netamount, 'INCOME', 'NONE', 'DEFAULT', 0, 0, 'DEFAULT'))) AS netamount

FROM

"TRANSACTION",

transactionLine

WHERE

"TRANSACTION"."ID" = transactionLine."TRANSACTION"

AND ((UPPER("TRANSACTION"."TYPE") IN ('SALESORD') AND NVL(transactionLine.mainline, 'F') = 'F' AND NVL(transactionLine.taxline, 'F') = 'F'))  ORDER BY TRANSACTION .trandate DESC NULLS LAST