Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a requirement to find moving avg value by each month within quarter.
Below is sample data with expected output of Moving Avg of output field. Can you please help me with solution.
Reporting_date | Amount | Qtr-Start | Moving Avg(Output value) |
25-Mar | 100 | 1-Jan | 100 |
31-Mar | 120 | 1-Jan | 110 |
4-Apr | 105 | 1-Apr | 105 |
10-Apr | 107 | 1-Apr | 106 |
31-Apr | 109 | 1-Apr | 107 |
4-May | 130 | 1-Apr | 112.75 |
29-Jun | 119 | 1-Apr | 114 |
30-Jun | 122 | 1-Apr | 115.33 |
1-Jul | 101 | 1-Jul | 101 |
Thank you
HI
Try like below
Dim: Qtr-Start
Dim2: Reporting_date
Exp1: Sum(Amount)
Exp2:RangeAvg(Above(Sum(Amount),0, RowNo()))
HI
Try like below
Dim: Qtr-Start
Dim2: Reporting_date
Exp1: Sum(Amount)
Exp2:RangeAvg(Above(Sum(Amount),0, RowNo()))