Table of Contents

Search

  1. Version 10.2.2
  2. Version 10.2.1
  3. Version 10.2
  4. Version 10.1.1
  5. Version 10.1

Statistical Functions

Statistical Functions

Effective in version 10.2.2, you can apply the following statistical functions to columns in a worksheet when you prepare data:
  • AVG
  • AVGIF
  • COUNT
  • COUNTIF
  • COUNTDISTINCT
  • COUNTDISTINCTIF
  • MAX
  • MAXIF
  • MIN
  • MINIF
  • STDDEV
  • STDDEVIF
  • SUM
  • SUMIF
  • VARIANCE
  • VARIANCEIF
For more information, see the "Prepare Data" chapter in the
Informatica 10.2.2 Enterprise Data Lake User Guide
.


Updated December 18, 2019