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

Query Join Calculation

Started by asr, 02 Feb 2011 09:02:55 AM

Previous topic - Next topic

asr

I am using multiple queries in my report and then joining these queries. One part of the join is not working where I am trying to do this:
The individual query calculates the opentime for each record and also the average.
The results are something like this in the 4 columns
open,opentime,name,average
2 0.49444444 XXX 6.36485164
1 13.34444444 YYY 6.36485164
1 0.39930556 ZZZ 6.36485164
1 0.3375 AAA 6.36485164

Now when I am joining this to another query I am losing these values
This is what I am getting when I join the query with another query.

XXX 1 1 6.36485164
YYY 2 1 6.36485164

that is - the column opentime is losing the values and only displaying the averages, wherasI need the individual values as in the first query. Why are the values showing only averages when I join the query? I couldnt figure this out on my own. Any help will be greatly appreciated,

thanks in advance