https://community.qlik.com/t5/App-Development/Calculation-with-filtered-data-range/m-p/1664867#M50021 <P>I'm not sure I understand properly what you are trying to do. Are you trying to get an average for the 3 most recent months per dock date yearmonth, or are you after a sliding type average regardless of the dock date?</P><P>This sounds like something RangeAvg would be good for, something like:</P><P><SPAN>rangeavg(above(sum([Avg Yield Rate]),1,3))</SPAN></P><P>This will give you a sliding average result, I've used above for the 3 most recent records, but depending on your sort order you can change that to Below or whatever is appropriate.</P><P>Hope that helps somewhat.</P><P>Rod</P> Mon, 13 Jan 2020 04:02:49 GMT Rodj 2020-01-13T04:02:49Z https://community.qlik.com/t5/App-Development/Calculation-with-filtered-data-range/m-p/1664863#M50020 <P>How to create a column where the expression of the column will be to only be average of the past 3 month avg yield rate (billing month)&nbsp; from the dock date for example if the dock date is 2020 Jan than the data use to calculate will be (0.60+0.66+0.68)/3</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/26732i1E6E513FC8ADACC6/image-size/large?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P> Mon, 20 Dec 2021 21:38:40 GMT https://community.qlik.com/t5/App-Development/Calculation-with-filtered-data-range/m-p/1664863#M50020 chaiwaykeat 2021-12-20T21:38:40Z https://community.qlik.com/t5/App-Development/Calculation-with-filtered-data-range/m-p/1664867#M50021 <P>I'm not sure I understand properly what you are trying to do. Are you trying to get an average for the 3 most recent months per dock date yearmonth, or are you after a sliding type average regardless of the dock date?</P><P>This sounds like something RangeAvg would be good for, something like:</P><P><SPAN>rangeavg(above(sum([Avg Yield Rate]),1,3))</SPAN></P><P>This will give you a sliding average result, I've used above for the 3 most recent records, but depending on your sort order you can change that to Below or whatever is appropriate.</P><P>Hope that helps somewhat.</P><P>Rod</P> Mon, 13 Jan 2020 04:02:49 GMT https://community.qlik.com/t5/App-Development/Calculation-with-filtered-data-range/m-p/1664867#M50021 Rodj 2020-01-13T04:02:49Z