Set Expression for Runnig Average by Quarter

[rfigueroa]

I'm trying to calculate the Running Average by Quarter

• For the first month of each quarter, the AVG will be the value of that month.
• For the second month, the AVG of the 1st and 2nd.
• For the third month, the AVG of the three months of that quarter.

Example: 

Already have columns A,B,C, need to calculate D

Thanks in advance

Robert

[madimadi · Accepted solution]

Hey,

try rangeavg(above(Avg_Qtr))

hope it helps.

[miskinmaz]

Try 

RangeAvg (Above(MyField,0,3))

 this will give you avg of three months

RangeAvg (Above(MyField,0,2))

this will give you abg of two months