A Running Total in Grouped Reports Gives Unexpected Results
You have a running total calculation in a grouped
report that returns unexpected values.
Because tabulation of the running total calculation depends on the order in which the grouping is executed, you must ensure that the grouped totals are tabulated before applying the running total.
To ensure that the grouping is executed in correct order, define a running total calculation as a freestanding calculation outside the query subject in IBM® Cognos® Framework Manager, and ensure that the Regular Aggregate property is set to Automatic.
This may also be an issue with other running, moving, and ranking aggregations.