Sales Report with Multiple Queries

[barrysaab]

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.

[barrysaab]

my database is oracle and version 8.4.Thanks,Anybody Please?

[PRIT AMRIT]

MTD MARGIN%,QTD MARGIN%,YTD MARGIN%

What is the logic for these items and how have you defined the expression for the same?