Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1. I have a table with the following field: Date, Order#, BO, Lines.
2. I want to sum up number of BO's and Line's over Order# and Date; I also want to take the percent sumBO/sumLines
3. I then want to take the average of sumBO/sumLines over all dates (ignoring Order#).
I was able to do all but the third line.
Can someone help.
Example Attached.
Here is the resulting table I would want:
Date | Average(SumBO/SumLines) |
6/1/2013 | 21% |
6/2/2013 | 23% |
Use the Aggr function.
Brg
//KArathorn