Average amount in certain time

Anonymous — Wed, 28 Mar 2018 13:01:02 GMT

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.

Re: Average amount in certain time

sunny_talwar — Wed, 28 Mar 2018 13:15:13 GMT

May be try this

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