| ANALYTIC FUNCTIONS |
| LAG |
Accesses data from a previous row in the same result set without the use of a self-join |
| |
|
| RUNNING VALUES |
| RunningCOUNT |
Calculate the running count of records in a partition without the use of a self-join |
| RunningSUM |
Calculate the running sum without the use of a self-join |
| RunningAVG |
Calculate the running average without the use of a self-join |
| RunningMAX |
Calculate the running maximum value without the use of a self-join |
| RunningMIN |
Calculate the running minimum value without the use of a self-join |
| RunningDEVSQ |
Calculate the running sum of squares of deviations without the use of a self-join |
| RunningSTDEV |
Calculate the running standard deviation without the use of a self-join |
| RunningSTDEVP |
Calculate the running population standard deviation without the use of a self-join |
| RunningVAR |
Calculate the running simple variance without the use of a self-join |
| RunningVARP |
Calculate the running population variance without the use of a self-join |
| RunningCORREL |
Calculate the running Pearson product moment correlation coefficienwt without the use of a self-join |
| RunningCOVAR |
Calculate the running covariance without the use of a self-join |
| RunningFORECAST |
Calculate the running forecast value without the use of a self-join |
| RunningINTERCEPT |
Calculate the running intercept without the use of a self-join |
| RunningRSQ |
Calculate the running square of the Pearson product moment correlation coefficienwt without the use of a self-join |
| RunningSLOPE |
Calculate the running slope without the use of a self-join |
| RunningSTEYX |
Calculate the running standard error in a regression without the use of a self-join |
| |
|
| MOVING VALUES |
| MovingCOUNT |
Count the number of moving rows without the use of a self-join |
| MovingSUM |
Calculate the moving sum without the use of a self-join |
| MovingAVG |
Calculate the moving average without the use of a self-join |
| MovingMAX |
Calculate the moving maximum without the use of a self-join |
| MovingMIN |
Calculate the moving minimum without the use of a self-join |
| MovingDEVSQ |
Calculate the moving sum of squares of deviations without the use of a self-join |
| MovingSTDEV |
Calculate the moving sample standard deviation without the use of a self-join |
| MovingSTDEVP |
Calculate the moving population standard deviation without the use of a self-join |
| MovingVAR |
Calculate the moving sample variance without the use of a self-join |
| MovingVARP |
Calculate the moving population variance without the use of a self-join |
| MovingCORREL |
Calculate the moving Pearson product moment correlation coefficient without the use of a self-join |
| MovingCOVAR |
Calculate the moving covariance without the use of a self-join |
| MovingFORECAST |
Calculate the moving predicted value without the use of a self-join |
| MovingINTERCEPT |
Calculate the moving intercept without the use of a self-join |
| MovingRSQ |
Calculate the moving square of the Pearson product moment correlation coefficient without the use of a self-join |
| MovingSLOPE |
Calculate the moving slope without the use of a self-join |
| MovingSTEYX |
Calculate the moving standard error without the use of a self-join |
| |
|
| MOVING AVERAGES |
| DEMA |
Calculate the daily exponential weighted moving average without the use of a self-join |
| DWMA |
Calculate a daily weighted moving average without the use of a self-join |
| RunningEWMA |
Calculate the running exponentially weighted moving average without the use of a self-join |
| MovingEWMA |
Calculate the exponentially weighted moving average without the use of a self-join |
| |
|
| INVENTORY CALCULATIONS |
| FIFO new! |
Calculate running FIFO (first in, first out) values without the use of a self-join |
| LIFO new! |
Calculate running LIFO (last in, first out) values without the use of a self-join |
| WAC new! |
Calculate running weighted average cost values without the use of a self-join |
| |
|
| Misc. Functions |
| XLDB_WINDOWING_VERSION |
Version Information |