I have a report with two tables:
table1 has two fields: an id as a string and an number
table2 has two fields: an id (matching entries in table1) and another number.
The problem is this:
I want to add values in table1 (grouped by id), round it up to the nearest whole number, then mulitply by the value in table2. This works fine and is displayed okay.
At the end of the report I want a sum of all the calculated values. When I try and create this I get the following two error messages:
* The summary field could not be created.
* This field can not be summarized.
Does anyone know a solution or a work-around?