Cognos 10 Row Calculation vs Column Calculation

[sean]

Hi, I have a cross tab gross profit report, it looks like the below:

                                       MTD Actual     MTD Budget    MTD Variance

Gross Sales (A)                   100                  80                  20
Cost of Good Sold (B)           70                  60                  10
GP= A - B                              30                  20                  10
GP% = GP/A                         30%               25%              50% (error)

The problem is GP% in 'MTD Variance' column is calculated as 10/20 = 50% (GP/Gross Sales) instead of 30% - 25%. Basically I need column calculation (MTD Variance) to overwrite row calculation (GP%). How can I achieve this?

Many thanks

[MFGF]

Hi, I have a cross tab gross profit report, it looks like the below:

                                       MTD Actual     MTD Budget    MTD Variance

Gross Sales (A)                   100                  80                  20
Cost of Good Sold (B)           70                  60                  10
GP= A - B                              30                  20                  10
GP% = GP/A                         30%               25%              50% (error)

The problem is GP% in 'MTD Variance' column is calculated as 10/20 = 50% (GP/Gross Sales) instead of 30% - 25%. Basically I need column calculation (MTD Variance) to overwrite row calculation (GP%). How can I achieve this?

Many thanks

Try selecting the GP% calculation and setting its Solve Order property to 2

Cheers!

MF.

[sean]

Thank you very much Champion.

Sean