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

Two queries without join

Started by aRaGaR, 03 Aug 2011 06:33:51 AM

Previous topic - Next topic

aRaGaR

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

Arpitagrawal9

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