Kbase P3582: Incorrect aggregate subtotals on a joint table report using Query/Results
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/11/2002 |
|
Solution ID: P3582
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Using Progress RESULTS
Wrong values displayed for subtotals on the joined table
Aggregate Subtotals on a joined report
FIX:
Workaround:
Creating NUMERIC calculated fields based on the columns in the first table that need to be totaled. The numeric expression should be the GREATER of TWO NUMBERS.
For example:
MAXIMUM(customer.credit-limit,customer.credit-limit).
This way the credit-limit value will always be returned.
Next create an Aggregate total by on this column and remove the original customer.credit limit column.
Change the labels of the column as appropriate and move the column to the required position.