Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 22 Jun 2011 10:50:31 AM

Title: Sales Report with Multiple Queries
Post by: barrysaab on 22 Jun 2011 10:50:31 AM
hello


I have Sales report with multiple queries which are joined.We have columns such as

MTD SOLD QUANTITY
   

MTD SOLD VALUE
   

MTD RETURN QUANTITY
   

MTD RETURN VALUE
   

MTD NET QTY
   

MTD NET SALES
   

MTD SOLD COST
   

MTD MARGIN
   

MTD MARGIN %



Same with Qtd and Ytd .On the basis of which we are creating two more report deleting previous columns item no,item desc,category.The problem is the whole values matching exactly the same but the differences is coming in MTD MARGIN%,QTD MARGIN%,YTD MARGIN%.I have change the aggregate and rollup aggregate properties for both the reports but still the difference remains the same.What shall be done. Please help.
Title: Re: Sales Report with Multiple Queries
Post by: barrysaab on 23 Jun 2011 02:15:13 AM
my database is oracle and version 8.4.Thanks,Anybody Please?
Title: Re: Sales Report with Multiple Queries
Post by: PRIT AMRIT on 23 Jun 2011 02:25:11 AM
QuoteMTD MARGIN%,QTD MARGIN%,YTD MARGIN%

What is the logic for these items and how have you defined the expression for the same?
Text only | Text with Images