Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.1
  3. Part 2: Version 10.4.0
  4. Part 3: Version 10.2.2
  5. Part 4: Version 10.2.1
  6. Part 5: Version 10.2
  7. Part 6: Version 10.1.1
  8. Part 7: 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 August 28, 2020