Statistical functions
These statistical functions are available.
| Function | Description |
|---|---|
| Average | Return the average of its arguments. |
| Cgr | Return the compound growth rate. |
| Count | Return the number of non-missing values. |
| FinVar | Return the variance using account type and account sign to determine if variance is favorable or unfavorable. |
| FinancialTotal | Return a total of its arguments adjusting for schedule line attributes. The calculation can include the Period, Year, Merged Period Year, Unit, Version, Schedule, and any custom dimensions. The Currency and Accumulation Method dimensions are not allowed in this calculation. The Rate, Rate set, and Adjusted state dimensions can be included but will not return a result. |
| Maximum | Return the argument with the greatest value. |
| Median | Return the median of its arguments. |
| Minimum | Return the argument with the smallest value. |
| Mode | Return the mode of its arguments. |
| PctFinVar | Express the FinVar as a percent. |
| PctVariance | Return the variance of the arguments as a percentage. |
| RankAsc PctFinVArP | Rank the argument you choose in ascending order, with respect to the opposite dimension on the grid. This function is not supported for members with alternate off-grid members. |
| RankDes | Rank the argument you choose in descending order, with respect to the opposite dimension on the grid. This function is not supported for members with alternate off-grid members. |
| Slope | Return the slope through its arguments. |
| Standardize | Return a value's normalized value. |
| StdDev | Return the standard deviation of its arguments. |
| Trend | Use the selected values as the input to the Trend "y" array, a progression from 1 - n representing the number of selected "Y" values is assigned to the Trend's X array. The next value after the "n" is assigned to the target "X" value. These are used to determine the appropriate slope. |
| Variance | Return the difference between its arguments. |
Missing values in variance calculations
If one argument to a variance calculation is missing, it is treated as a zero. If both arguments are missing, they are treated as missing values.