# Qlik Sense App Development

Valued Contributor II

## How to compute average sales per day ?

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

1 Solution

Accepted Solutions
MVP

## Re: How to compute average sales per day ?

It could be (with dimension of Month)

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

4 Replies
MVP

## Re: How to compute average sales per day ?

It could be (with dimension of Month)

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

MVP

## Re: How to compute average sales per day ?

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

Contributor II

## Re: How to compute average sales per day ?

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.

Valued Contributor II

Hi Sir

Thank you.

Paul