If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Column not aggregating correctly, need help please

Started by bz_boy, 20 Jul 2018 02:00:13 PM

Previous topic - Next topic

bz_boy

Hello all. I am having trouble getting a "Revenue" column to aggregate correctly. For this particular column, the value for this particular client should have a revenue of $200. When I run the report, the value for revenue for this client is astronomically high with a revenue of $39,500.

I have tried multiple trial and errors but still can't get it to work correctly. Can someone please offer a suggestion of how I can get this to work correctly? When I run the query in SQL Server the value shows correct, however in Cognos 11 Business Analytics the value is incorrect.


What else could I try?

Thank you in advance

sdf

I am guessing your Revenue item is a calculation. And what you want is to just total all the values of the revenue (total the rows)?

How are you calculating the revenue?
How are you aggregating?

Well you can try some of the basic to check. Select your Revenue column and in the properties look for Solve Order, Change it to 2.

make sure you are using the correct aggregate function and property.
Try to set as calculated then total or automatic.