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 ?
It could be (with dimension of Month)
Sum(Sales) / Day(MonthEnd(Month))
Adjust the field names to the correct names for your model.
If Month is not a date, convert to a date using MakeDate, and use that in the MonthEnd statement.
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.
Retrieving data ...