MINX

Description

The MINX function calculates a value for each row in a table, and then finds the minimum of the calculated values.

Usage

MINX(TABLE_EXPR, EXPRESSION)

Example

You can use the MINX function in a pivot table to find the youngest beneficiary.

For example, if you had a quantity field in your form with AGE of the beneficiary, then you could write:

MINX([Beneficiaries], AGE)

The second argument can be expression in a row context, for example if we wanted to find the average of our beneficiaries at particular moment in time, we could write:

MINX([Beneficiaries], YEARFRAC([Date of Birth], DATE(2023,1,1)))

This finds the youngest beneficiary age on January 1st, 2023.

Next item
NOT EQUAL (!=)