KNOWLEDGE BASE

Median Function Unavailable


Published: 16 Sep 2013
Last Modified Date: 18 Jan 2017

Issue

When you try to create a calculated field, the MEDIAN function is not available.

Environment

  • Access
  • Amazon Redshift
  • Cloudera Hadoop
  • Excel
  • HP Vertica
  • IBM DB2 zSeries
  • MySQL
  • SQL Server
  • Text files
  • Teradata
  • IBM Netezza (aka IBM PDA)
  • Tableau Desktop

Resolution

As a workaround, create an extract. For more information, see Extracting Data.

Cause

The MEDIAN function is not available for live connections to the data sources listed in the Environment section.

 

Did this article resolve the issue?