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

Different values in list and in chart

Started by ArnaudStephanHTH, 12 Oct 2020 05:01:53 AM

Previous topic - Next topic

ArnaudStephanHTH

Hello,

I have a list report that a user would like to be in chart form. I'm facing a strange problem, because the list and the chart show completely different values, even though they are based on the same query

List values, with supplier N** being the first with 464 800 units. This is the correct number.



Chart values, this time supplier N** is second with 12 549 600 units.



As you can see, both items are based on the same query :






What am I missing ?

BigChris

That looks like an aggregation problem to me

ArnaudStephanHTH

Indeed it is, the agregation was set to Default and it worked when I put it as Minimum. But why were the values different in the list and in the chart ?