Average for each three months

Hello,

I have the next situation.
I need to calculate a revenue for the December which are an average for the last three months.
The exact situation.

KP	Date	Amounts
Revenue	2019-09-01	11112
Revenue	2019-10-01	1125
Revenue	2019-11-01	2563

The revenue for December will be AVG(amounts).

Then I want to save this value in DB and I will have the next value in a table.

KP	Date	Amounts
Revenue	2019-09-01	11112
Revenue	2019-10-01	1125
Revenue	2019-11-01	2563
Revenue	2019-12-01	4933

Then the revenue for January will be avg for the last three months and the avg will be save in db.

How to do this in for one year?

Date Time

Dynamic Processing

Accepted answers

meljaafari

Hey @Ecaterina,

I attached a workflow which may help you achieve the result you want.

It generates a new row (or multiple rows ups to the current month) every time you run the workflow, and calculates the running average based on the Amounts value for the 3 months prior.

Hope this helps,

Last 3 Months average.yxmd

RolandSchubert

Hi @Ecaterina ,

I've extended the workflow created by @meljaafari a bit to include the iteration. You can create additional periods by modifying the condition expression within the Generate Rows tool, I used "< DATETIMEADD([Max_date], 12, 'month') to generate 12 periods. Average is calculated by using the Multi-Row formula tool.