G
Guest
Can anyone provide information about writing expression across rows?
An example is I have some data in Field1 (say 200 records). I would like to write an expression that returns a moving average of n days (parameter) when the qurey is run.
Also what are the overheads involved in this. Am I better off retriving the data to excel and calculating with spreadsheet functions.
Any info appreciated
Bruce
An example is I have some data in Field1 (say 200 records). I would like to write an expression that returns a moving average of n days (parameter) when the qurey is run.
Also what are the overheads involved in this. Am I better off retriving the data to excel and calculating with spreadsheet functions.
Any info appreciated
Bruce