Moving Average Formula Issue

[Nick Parrillo 2]

I am trying to get a 5 day moving average of some Gas/Oil Ratios. First I am calculating the GOR off daily gas and oil data, then trying to average out. This is the equation that is not working:

 

([Gas/Day]*1000)/[Oil/Day] then Avg([Value]) over (Intersect([Well Name], LastPeriods(5,[Days])))

Any help would be appriciated.

 

Thank you

[Alain Martens]

Hi,

Please try toremove theintersect[well name] fromthe expression like show in the attached screenshot.

Best regards,

Alain

[Nick Parrillo 2]

But dont I need that if I have multiple wells listed for this calculated column