Average amount in certain time

[Anonymous]

Hi everyone,

I am trying to calculate the average amount of incoming invoices. e.g.:

Month:               Amount:

Jan 2017               15

Feb 2017               21

Mar 2017               36

Apr 2017               23

May 2017               25

Jun 2017               37

Jul 2017               29

Aug 2017               34

Sep 2017               26

Oct 2017               15

Nov 2017               24

Dec 2017               23

Jan 2018               44

Feb 2018               42

Mar 2018               39

So I have all this in a Chart. Now I'd like to compare it with the average amount for the past 12 months. So, for March 2018 I want the result to be:

sum (Amount from Mar 2017 to Feb 2018) = 358 devided by 12 (months) = 29.83

For Feb 2018 it'd be:

sum (Amount from Feb 2017 to Jan 2018) = 352 devided by 12 (months) = 29,33

Any suggestions how to do it?

Thanks in advance.

[sunny_talwar]

May be try this

RangeAvg(Above(Sum(Amount), 0, 12)