Average of the previous 3 months data

Luis98
Occasional Contributor

Average of the previous 3 months data

Hello,

I have a question, 

If i want to pull the average of the previous 3 months, how can i do it? 

 

Thanks

1 REPLY 1
Misbah
Moderator

@Luis98 

 

Try using MOVINGSM function

 

Formula may look like

MOVINGSUM(Line item,-2,0,AVERAGE) 

 

Misbah