How to compute average sales per day ?

[paulyeo11]

Hi All

Can some one share with me how to compute the average sales per day ?

For example sales for the month of May 2015 is $30

Average sales per day it is = $30/30 = 1

it is correct ?

Paul

[jonathandienst · Accepted solution]

It could be (with dimension of Month)

     Sum(Sales) / Day(MonthEnd(Month))

Adjust the field names to the correct names for your model.

[jonathandienst]

If Month is not a date, convert to a date using MakeDate, and use that in the MonthEnd statement.

[santhoo_san]

Average sales per day =

( Total Sales for a period

/

No of days of that period (No of working days in some cases))

in your example as a general case = it is $30 / 31 (May has 31 days) = 0.968.

[paulyeo11]

Hi Sir

Thank you.

Paul