How to summarize a Complex Query subtotals and averages
Posted on 2005-04-18
I have a query that pulls information from a large number of tables
Basically is information regarding warehousing
I have for every part number anywhere from 10 to 100 records that include the following fields.
All the following fields REPEAT EXACTLY THE SAME On EVERY ROW Returned for the PART NUMBER
Date, location ,Planner_ID ,Planner_Name, Product, Description,Basic_UM, locationRC, TotalCIPRC, On_OrderRCN, OnHandRCN
All these fields are different for every row on the returned results
CIPDC , MTDDemandDC , ForecastDC
What I need to Do is a query that will have ONLY one record for every part number.
And for the NON repeating fields It will give me the sum for CIPDC , MTDDemandDC , ForecastDC.
Once I have this I can perform calculations on the data that I need to do.
It may be an easy question but I spent all day getting this information out of three separate systems (If you’ve dealt with SAP and AS400 at the same time you’d know what I’m talking about).
If you have any question please do let me know.
As we speak I’m checking my A2KDH to see if I can get reoriente but I seem to have ran out of steam for today and I need to deliver this report.