Calculate Average weekly sales.

symas

Hi Experts,

I have to calculate 7 days sales average but condition is to take only those days having sale is greater then 0.

any suggestion?

Thanks

Slawek_Guzek

Go through T21 Cust Ledger Entry, filter for Document Type=Invoice|Credit Memo, sumarize Sales (LCY) grouping by posting date, if sum per day is >0 add it to your average

Slawek_Guzek

Go through T21 Cust Ledger Entry, filter for Document Type=Invoice|Credit Memo, sumarize Sales (LCY) grouping by posting date, if sum per day is >0 add it to your average