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