GOR Moving Average

[Nick Parrillo 2]

HELP!

All,

I have a list of many wells that I wish to calculate GOR (Gas Oil Ratio) on and then get the 3 day moving average of said values in a calculated column. The formula I am using keeps generating an error and I cannot figure out why. Any help Here is the formula I have been using and an example of the type of the data.

 

([Gas/Day] * 1000 / [Oil/Day]) THEN Avg([Value])OVER Intersect([Well],LastPeriods(3,[Days]))

Error is saying not valid expression after "Then"

 

Thank you

[Khushboo Rabadia]

Once you have used "THEN" you cannot use other columns like wells, days etc. THEN is used for post aggregation and use of only [Value] would be allowed or if you are using the custom expression on any visualization then [Axis.X] or [Axis.Color] would also be allowed after then.

You can try to use below expression:

Avg(([Gas/Day] * 1000 / [Oil/Day]))OVER Intersect([Well],LastPeriods(3,[Days]))