Cognos Crosstab Report Calculated Column Totalling Incorrectly

3.7k Views Asked by At

I have a report in Cognos 10.1.1 that is pulling Profit, Pounds, and Profit/Lbs. Each query has a field 'Measure Unit' that is labeled as 'Spread $', 'Spread Lbs' or 'Spread $/Lb'. It joins these three queries via a union and then loads them into a Crosstab list. The individual queries work correctly, and when dumped into a List Report are fine, but for some reason when in the crosstab report, the calculated profit/lbs column is always wrong. How can I get the calculated column to total correctly in the crosstab?

Query Structure

Three queries pull seperate Measure Units and measures for Profit, Lbs and Profit/Lbs.

Profit Measure Calculation

The calculation for Profit.

Spread $/Lb Measure Calculation

The Calcuation for Profit/Lbs

Spread Measure Calculation Properties

Properties for the measure fields.

Final Report Sample

What the report looks like. Middle column should equal Spread $ / Spread Lbs, but does not when in crosstab.

1

There are 1 best solutions below

2
On BEST ANSWER

Try to customize Solve Order for your calculations. Default behavior is Total(Value1/Value2). You need to archive Total(Value1)/Total(Value2) (Don't change your formulas, just set Solve Order for calculations)