SQRT

Returns the square root of a value in a numeric field.

Where the source value is negative, SQRT will return null.

SQRT ( <field_name or value> )
  • field_name or value: The numeric field or value to perform the calculation on.

Example: create a field at the CUSTOMER level that returns the square root of their change in value.

SQRT [CUSTOMER.CHANGE IN VALUE] )