Joel,
You can get this result in your code, referencing the totalrow, by the use of the rowtotal constant. You have to set your COL_Amount to calculate the sum. This can be done on the details-tab of that column.
i.e.: cyResult = InvoiceTable.Amount[rowtotal]
Arie