max Function

Description

Take an array as an argument and return the max in that array.

If you specify something that does not represent a number, NaN (indicating that it is not a number) is returned.

Usage Examples

The following example returns the max value in the Number column of a destination table with the field code “table” plus 1.

= max(table.Number) + 1

The following example calculates the ratio of maximum to minimum values for the Number column in a destination table with the field code “table”.

= min(table.Number) / max(table.Number)

Precautions

  • In Kintone, date and time fields are not numbers, so if you want to calculate date and time max, use stringmax instead of max.

関連記事