COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: aRaGaR on 03 Aug 2011 06:33:51 AM

Title: Two queries without join
Post by: aRaGaR on 03 Aug 2011 06:33:51 AM
Hello all,
Broadly speaking - I have two queries which give me two numbers (totals) and I want just to show the division of these two numbers. I know one way is to join (or union) the two queries in new one and this way to get the numbers. Is there any other way without joining, unioning etc, because it seems a little slow for such a simple calculation? Is there some way to store the values in something like a variable and to use it later?
Thank for the help in advance
Title: Re: Two queries without join
Post by: Arpitagrawal9 on 08 Aug 2011 05:21:16 AM
U can unlock the list and use Singletons in your report and associate the query to them as the query would only give you one grand total