I have a calculation in my report that takes the results of column A (standard hours) / results of column B (actual hours) and I do not get the expected result. The calculation that is incorrect is the one on the summary line - the detail lines work correctly. I have the total defined as a calculation. Any suggestions of why this is not working correctly?
You probably need to force Cognos to take the proper order in the calculation. It needs to total the results for the first column , then perform the same for the second column and then perform the division for the summary, like:
total([fact1]) for report / total([fact2]) for report
In addition to suggestion above, you have to change/play with the aggregate and rollup aggregate properties to tell cognos how to aggregate the value.