Nach der Aggregation berechnen is the German label for the Calculate after aggregation setting.

Here are links to some relevant parts of the Cognos documentation.

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/t_ca_mdlg_custom_calculations.html

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/t_ca_mdlg_calculations.html

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.mod_guidelines.doc/c_mod_guidelines_aggregation.html

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

Original Message:
Sent: Thu March 18, 2021 06:27 AM
From: Rizwan Iqbal
Subject: Calculated field within a table

Hi Timm,

Thanks for your message. I was trying to compute the sum of column C + sum of column D and divide the result with the sum of column E from a table (say the table has columns A to E) and save it as a calculated filed F. What I did not do was to enable the tick in the below box unknowingly :-(


This did not give me the required result and I was wondering what I have been doing wrong (It was my day 1 learning and developing a dahsboard, and I got struck)

I have learned now to set a tick at the very bottom to enforce the calculated field to do the right job. 

Best regards,
Rizwan

------------------------------
Rizwan Iqbal

Original Message:
Sent: Thu March 18, 2021 04:51 AM
From: Timm Rosengarten
Subject: Calculated field within a table

Hi Rizwan,

I do not quite follow you on your example, but what you can is to create calcuations in Dashboards with the full functionality of expressions (context menu next to the data source). However the calculation is only available in this specific Dashboard. What I would rather recommend is to create a Datamodule first, where you you can persist the calculation in the Datamodule also for other Dashboards.

Regarding the totals, you can use e.g. total([Column C] for report) + total([Column D] for report) / total([Column E] for report). As mentioned I dot not quite understand what you mean with levels in Column A and B.

Best regards,
Timm

------------------------------
Timm Rosengarten
Senior Consultant Analytics
TIMETOACT Software & Consulting GmbH
Seligenstadt

Original Message:
Sent: Wed March 17, 2021 07:27 AM
From: Rizwan Iqbal
Subject: Calculated field within a table

Hello, I am totally new to IBM Cognos Dashboarding. I want to know whether it is possible to create a calculated field based on multiple variables while creating a dashboard. Say A, B, C, D and E are columns in a table read through an excel file, where A and B are factor variables with various levels and C to E are numeric variables. I want to define a new column say F such that F = ((sum of all values in Column C + Sum of all values in D) / Sum of all values in E). This F must change dynamically as the levels in A and B are chosen.

How can this be done? Any link/ source please.

------------------------------
Rizwan Iqbal
------------------------------