avg on total per salesorder

[chriscools]

Hello,

i was trying to calculate the avg amount sold in our shops per weekday.

i have a table with all the different saleslines and in 1 column i have the sales-id number.

if i calculate an avg i have the the avg per line, but what i want is to calculate the avg per salesorder, but i'm lacking the total per salesorder in my table.

what do i do to calculate my avg per salesorder?

thanx for your help!

Chris

[#2]

Hi,

If you want to do this in the script 'Group' you data by salesorder.

If you want to do this on the front end try:

(sum(sold))/(sum(total<salesorder> sold))

Regards

Rahul Lakhina