COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: terryc525 on 13 Dec 2008 12:24:24 PM

Title: How to create calculation for 2 different Query ?
Post by: terryc525 on 13 Dec 2008 12:24:24 PM
I get trouble to calculate the total value between 2 different query and place it into a table cell.

I tried to create my own calculation in Report Studio but can't work.

Any suggestion for me ?

Thanks a lot !
Title: Re: How to create calculation for 2 different Query ?
Post by: blom0344 on 15 Dec 2008 03:51:35 AM
There needs to be a association between the 2 queries (like a join or a union) that is the basis for a third query. The third query will allow you to define math between query items.