7 Replies Latest reply on Apr 18, 2016 10:03 AM by Yuriy Fal

# What is the calculation for 'run rate' that changes by day?

Hi All!

I do not know how to create a 'run rate' calculation and hope someone can tell me what the proper calculation would be? Here's the problem:

I need to take the number of days that has passed in the current month and then divide by the total revenue up to that day. That result would then be multiplied by the number of days in the current month to get to our run rate for the month.

So if i had \$100 in revenue through the 5th of January, I need to divide \$100/5 days which would equal \$20. Then I would take that result and multiply it by the number of days in January, so \$20*31= \$620. That would be my 'run rate' as of the 5th of January for the entire month of January.

I need to have this calculated daily though, so on January 10th with MTD revenue of \$300, I need Tableau to calculate (\$300/10)*31, and so on and so forth for each of the following months

Jimmy

• ###### 1. Re: What is the calculation for 'run rate' that changes by day?

Hi jimmy,

Something like this?

Please find the attached wb (version 9.0).

Hope it could help.

Yours,

Yuri

1 of 1 people found this helpful
• ###### 2. Re: What is the calculation for 'run rate' that changes by day?

Hi Jimmy,

• ###### 3. Re: What is the calculation for 'run rate' that changes by day?

Thanks Ying - let me try this and will get back to you guys!

• ###### 4. Re: What is the calculation for 'run rate' that changes by day?

Thanks Yuriy, let me try this and get back to you!

• ###### 5. Re: What is the calculation for 'run rate' that changes by day?

Hi Yurily, thanks again for the workbook, and it's on the right track, however it looks like the workbook is calculating the specific day's sales, then dividing by the number of days associated with the date of the sale. I need the calc to be dynamic and sum up the total sales through that day.

Example:

Date                    Sales

Jan 1, 2016         \$50

Jan 2, 2016         \$45

Jan 3, 2016         \$35

Jan 4, 2016         \$38

Jan 5, 2016         \$42

Total thru Jan 5th (we're assuming today is Jan 5th, 2016) =  \$210

Run rate = (\$Sum of sales thru current day/number of days thru the current day)* number of days in the current month

or (\$210/5)*31= \$1,302

So the run rate as of January 5th for the entire month of January would be \$1,302.

____________________________________________________________________________________________________

Once we hit January 6th, we would then add the sales on January 6th

Example:

Date                    Sales

Jan 1, 2016         \$50

Jan 2, 2016         \$45

Jan 3, 2016         \$35

Jan 4, 2016         \$38

Jan 5, 2016         \$42

Jan 6, 2016         \$55

Total thru Jan 6th (we're assuming today is Jan 6th, 2016) =  \$265

Run rate = (\$Sum of sales thru current day/number of days thru the current day)* number of days in the current month

or (\$265/6)*31= \$1,302

So the run rate as of January 6th for the entire month of January would be \$1,369.17.

• ###### 6. Re: What is the calculation for 'run rate' that changes by day?

Hi Jimmy,

This is exactly how [Run Rate] is calculated in my wb.

Yours,

Yuri

• ###### 7. Re: What is the calculation for 'run rate' that changes by day?

Hi Yuriy - yup you're right, this is what I was looking for! Thank you!!!!