• h3. DESCRIPTION:

The min() function is applied to arrays in order to calculate the minimum value among the values in a specific field returned by the select() statement that created the array.

SYNTAX

  • min(x)
  • min(Path)

WHERE

  • min is the function keyword. This must be entered into the Ninox function editor in all lower-case characters
  • x is a variable that contains (points to) the results of select statement
  • Path is a series of ‘Table Names’ and, optionally, a ‘Field Name’ that indicated to Ninox where to find the contents of the array to be returned and analyzed. The path may stay inside of the family or cross over table boundaries to terminate at schema locations other than those inside the current stack or data family.

EXAMPLE

  • let x := select ‘Customer Invoices’.‘Invoice Total’ / min(x)

SEE ALSO

arrays
select()
Path
Data Family

Revision: 2
Last modified: 2019/11/10

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment