topic Re: How to compute average sales per day ? in App Development

How to compute average sales per day ?

paulyeo11 — Wed, 17 Jun 2015 08:59:09 GMT

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 — Wed, 17 Jun 2015 09:01:44 GMT

It could be (with dimension of Month)

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

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

jonathandienst — Wed, 17 Jun 2015 09:03:03 GMT

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

santhoo_san — Wed, 17 Jun 2015 09:41:44 GMT

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 — Wed, 17 Jun 2015 11:00:32 GMT

Hi Sir

Thank you.

Paul