Hello,
I have a group called Part number with a few production jobs with in that group. I also have a SPQ (Std Production Qty) for each Part number. I have a formula called @AvgMQty that gets the average prodution qty. I have another formula called@diff that takes the ((SPQ-AvgMQty)/SPQ)*100 and I want to sort my report by this formula
The Idea is to run the report for a given date range and show the Parts that have largest percent difference between the SPQ qty and what production is running. I want to show the largest difference at the top of the report becasue the report can be very long.
I've found a few other forums where people say this cannot be done becasue you can't sort a group using a "SUM" type of formula.
I would think what I'm doing is very common and someone knows how to do it!!!
thanks for your help