Mat Sales Calculation

Add your mat sales as you did above.

Mat sales calculation.

The second parameter specifies the date range using the datesinperiod function. Based on the previous example you would take 20 million and subtract it from 75 million and get 55 million. This is a rolling yearly sum so changes at the end of each month with data from the new month added to the total and data from the first month of the period taken away. Calculated generally once a month it means mat sales june 2010 will include sales from 1st july 2009 to 30th june 2010 and mat sales july 2010 will consist of sales from august 2009 to july 2010.

Sumproduct e 2 e2 f 2 f2 date year f2 month f2 12 1 update your pivottable data source to include these columns. Please note if your data source is a table i would change the calculations slightly. If financial period date formatted removal financial period start and financial period date formatted removal financial period end then gross sales revenue end. Mat date assumed to be column f.

Then on october 1st 2019 that amount was 20 000. Moving annual total mat the total value of a variable such as sales figures for a product over the course of the previous 12 months. This is a rolling yearly sum so changes at the end of each month with data from the new month added to the total and data from the first month of the period taken away. In simple word it is last 12 month revenue sales.

How to calculate days sales outstanding or dso let s take an example to show how the days sales outstanding formula works. Mat is for the past 12 month sales comparing two points mat data evens out the fluctuations. Divide by the previous month s sales and then multiply the result by 100. For example feb 2014 to jan 2015 sales are called mat feb 2015 sales.

Mat moving annual total calculate sum transactiondata revenue datesinperiod calenderdate date lastdate calenderdate date 1 year this formula uses calculate where the first parameter is the value that gets returned. To get the sales rate subtract the previous month s sales from the current month s sales. The 55 million represents the growth. Calculation of mat sales.