Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next



Extracts the ranked value from the values in a column, where k=1 returns the maximum value, when a specified condition is met. The value for k must be between 1 and 1000, inclusive.   Inputs can be Integer, Decimal, or Datetime.

KTHLARGESTIF calculations are filtered by a conditional applied to the group.  


Input column can be of Integer, Decimal, or Decimal Datetime type. Non-numeric data in the column is Other values column are ignored. If a row contains a missing or null value, it is not factored into the calculation.


Name of the column whose values you wish to use in the calculation. Column  Inputs must be a numeric ( Integer or Decimal) type, Decimal, or Datetime values.


NOTE: If the input is in Datetime type, the output is in unixtime format. You can wrap these outputs in the DATEFORMAT function to output the results in the appropriate Datetime format. See DATEFORMAT Function.

D s

Required?Data TypeExample Value
YesString that corresponds to the name of the columnmyValues