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.
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.
Thanks, that got me going. The queries didnt have the same number of items, but I managed to work around it.
Try 2 use tabular set....
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.
Oh ok...thank u
Hi JhonnyCat,
can you tell me how you were able to solve this issue.
Thanks...