Calculating a Value Based Off a Subtotal

[LeonelSanchezJr]

I am using Developer Studio 714 and I am using SUM in my report to get the following report:

MDL MTD YTD DAYS DAYS
SALES SALES IN_STOCK 2RETAIL MTD_VOLUME
BMW325 2 15 2509 886 62.87
BMW330 2 4 471 183 12.11
BMW525 1 6 1080 301 25.57

*SUBTOTALS 5 49

The MTD_VOLUME column should be calculated as such:
(DAYS_IN_STOCK + DAY2RETAIL) / (SUBTOTAL OF MTDSALE + SUBTOTAL OF YTD SALES)

Currently, my report is dividing at the detail line level.
How can I do this?



Thanks,

Leo ;-)

 

[focwizard]

How is the MTD_VOLUME being calculated at the detail level? If it's the same calculation,then you should do the detail calculations with a COMPUTE, and use SUMMARIZE instead of SUBTOTAL.

 

[LeonelSanchezJr]

Yes, it's being calculated at the detail level.
I will try that...thank you.

Thanks,

Leo ;-)