New Statistical Custom Functions in Calculation Manager
Several new statistical custom functions are available:
- @CalcMgrExcelBINOMDIST: Returns the individual term binomial distribution probability
- @CalcMgrExcelNORMSDIST: Returns the normal distribution
- @CalcMgrExcelNORMSINV: Returns the value z such that, with probability p, a standard normal random variable takes on a value that is less than or equal to z.
- @CalcMgrExcelPERCENTILE: Returns the k-th percentile of values in a range
- @CalcMgrExcelPERCENTRANK: Returns the rank of a value in a data set as a percentage of the data set
- @CalcMgrExcelRANK: Returns the rank of a number in a list of numbers
Applies to: Financial Consolidation and Close, Planning, Tax Reporting
Business Benefit: Introduction of new custom functions makes creating calculation scripts easier.
Key Resources
- Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud