BRFplus: Sum Amount in Table
We are having trouble summing amount columns of tables in BRFplus. We have tried 2 different ideas and each has a different error:
- Table Operation - sum the column containing the amount. This returns a currency error. It is not possible to pass a currency at runtime because it does not exist in the table structure.
- TABLE_SUM_AMOUNT - create a formula and use this function to calculate the amount. This always returns the error "Column 0050569BA4BE1EE487810606D083E1 does not exist in table Table Type." Regardless of the column or the table type, this same error appears for all TABLE_SUM* functions.
Any ideas? Your help would be greatly appreciated.