We recently upgraded from Cognos 8 to 10. When I used Cognos 8 report studio I was able to use the aggregate function under the Sum function in the toolbar but I don't see it there now. This is what I am trying to do and it so simple but is not working as easily as it did in Cognos 8. Take Column B / Column A. So for instance:
Column B Column A
76 441 = .17
57 366 = .16
83 1004 = .08
___________________________
1811 216 = .12
To calculate the .12 value I used the aggregate function under the summary function found in the toolbar. I was not required to set up a data item in the query. Now that function is no longer there. I have been able to get some of the similar calculations to work after playing around with the aggregation of the data item but I am unable to get this particular calculation to display correctly. What is the correct way that I should be handling this to easily get the value of .12. Thanks in advance!
Column B Column A
76 441 = .17
57 366 = .16
83 1004 = .08
___________________________
1811 216 = .12
To calculate the .12 value I used the aggregate function under the summary function found in the toolbar. I was not required to set up a data item in the query. Now that function is no longer there. I have been able to get some of the similar calculations to work after playing around with the aggregation of the data item but I am unable to get this particular calculation to display correctly. What is the correct way that I should be handling this to easily get the value of .12. Thanks in advance!