Hi

I am using IBM Cognos Analytics 11.1 R1. I am suddenly having a problem with calculation. I have one column A with a total of 10600000 and other column B with a total of 7900000. When I create a calculated field of Column A + Column B and it displays 13600000 instead of the right summation of 18500000.

What could be Any advice?


------------------------------
HWEE LEE YEO
------------------------------

#CognosAnalyticswithWatson

What's the aggregation for your calculation?   Quite often the problem which you are seeing is corrected by setting the aggregation to calculated.

------------------------------
IAN HENDERSON
------------------------------

Hi

Under Properties, I cannot find the option Calculated in the Aggregate properties. I can only see None, Total, Average, etc.

------------------------------
HWEE LEE YEO
------------------------------

Original Message:
Sent: 02-17-2019 03:11 PM
From: IAN HENDERSON
Subject: Strange Calculation Results

What's the aggregation for your calculation?   Quite often the problem which you are seeing is corrected by setting the aggregation to calculated.

------------------------------
IAN HENDERSON
------------------------------

Hi,

Calculated aggregation type is only available for what we call "Stand-alone" calculations, defined outside of a "table", aka query subject.

A more detail answer is available in this thread, including example:
https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?MessageKey=0db8bc46-1b33-4f66-a598-dc114a86742b&CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=digestviewer

Thanks,
Valentin

------------------------------
VALENTIN BALTEANU
------------------------------

Original Message:
Sent: 02-27-2019 10:24 AM
From: HWEE LEE YEO
Subject: Strange Calculation Results

Hi

Under Properties, I cannot find the option Calculated in the Aggregate properties. I can only see None, Total, Average, etc.

------------------------------
HWEE LEE YEO
------------------------------


Original Message:
Sent: 02-17-2019 03:11 PM
From: IAN HENDERSON
Subject: Strange Calculation Results

What's the aggregation for your calculation?   Quite often the problem which you are seeing is corrected by setting the aggregation to calculated.

------------------------------
IAN HENDERSON