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

Total two columns from different queries

Started by JohnnyCat, 25 Jul 2006 12:45:25 PM

Previous topic - Next topic

JohnnyCat

Hello,

I have two different queries in my report.Ã,  Both are a count of employee, but they are from different tables.Ã,  How can I calculate the sum of all employees in list A and employees in list B, i.e. have a grand total of all employees from both lists?Ã,  Also, there is no relationship between these two tables.Ã,  Some employees are stored in table A, others are stored in table B.Ã,  I am using Cognos 8.

Thanks for your help.

MFGF

If the queries have the same number of items (with the same data types) you can union the queries together into a higher-level query, and perform your calculation there.

Regards,

MF.
Meep!

JohnnyCat

Thanks,  that got me going.  The queries didnt have the same number of items, but I managed to work around it.

mrcool


MFGF

Hi MrCool,

Just to clarify, there's no longer any such thing as a Tabular Set in Cognos 8, which JohnnyCat is using here.  Tabular Sets have been replaced by Query Unions in Cognos 8.

Regards,

MF.
Meep!

mrcool


tosty

Hi JhonnyCat,

can you tell me how you were able to solve this issue.

Thanks...