SDEV

Returns a number that represents the standard deviation of a parents child records.

SDEV ( <field_name> [, <filter_query>] )

  • field_name: The name of the field to use in the calculation.

  • filter_query: A query string representing the domain of records to include.

Example: for each customer calculate the standard deviation for all purchases with a value > 38.

SDEV([TRANSACTION.VALUE],[TRANSACTION.VALUE] > 38)