crystal123456
Programmer
Hello,
I am creating a report that pulls in products that are forecasted by our customers. The way my report works is the user inputs an end date, and the report goes out and pulls in all of the products that are forecasted up to that date.
On my report I display Part Number, Part Description, Quantity Forecasted, Date for each quantity.
The report gets grouped first by which line it runs on, then by the parts family part number, and then finally by date which I break up by month.
I had to sort by date because depending on the volumes on our product, we will forecast by week or by month.
My goal of this report is to get an average of each products forecast by month.
So, I Summed the quantities for the months under the month group.
Then to get what I am looking for I need to average these Sums for the month under the product family group.
When I try to average this field, Crystal will not allow me to do so and only gives options for Maximum, Minimum, Distinct count, etc...
I have tried creating formulas, but it gives an error and says "Field cannot be Summarized".
There is also no guarantee how many months will fall under a product family, so when averaging it will need to recognize how many months to average over.
Any help would be greatly appreciated, I am using Crystal 11 FYI
Thanks,
Michael
I am creating a report that pulls in products that are forecasted by our customers. The way my report works is the user inputs an end date, and the report goes out and pulls in all of the products that are forecasted up to that date.
On my report I display Part Number, Part Description, Quantity Forecasted, Date for each quantity.
The report gets grouped first by which line it runs on, then by the parts family part number, and then finally by date which I break up by month.
I had to sort by date because depending on the volumes on our product, we will forecast by week or by month.
My goal of this report is to get an average of each products forecast by month.
So, I Summed the quantities for the months under the month group.
Then to get what I am looking for I need to average these Sums for the month under the product family group.
When I try to average this field, Crystal will not allow me to do so and only gives options for Maximum, Minimum, Distinct count, etc...
I have tried creating formulas, but it gives an error and says "Field cannot be Summarized".
There is also no guarantee how many months will fall under a product family, so when averaging it will need to recognize how many months to average over.
Any help would be greatly appreciated, I am using Crystal 11 FYI
Thanks,
Michael