Attribute Arithmetic Operators

The arithmetic operators allow you to determine the maximum and minimum value of an attribute for items that have been selected in a relationship. You can also sum the values of the attributes.

The operators take one argument, which is the path to the attribute. Attributes can be of type Number, Integer, Date, or Time. DateTime and Text are not supported. If the type is Date or Time, minAttr returns the time or date closest to the present. The maxAttr operator, returns the time or date furthest from the present.

Use the attribute arithmetic operators shown in the following table to create subexpressions that form conditions.

Operator	Syntax	Properties
Minimum	minAttr(A)	For items selected from a relationship, returns the smallest value for attribute A.
Maximum	maxAttr(A)	For items selected from a relationship, returns the largest value for attribute A.
Sum	sumAttr(A)	Returns the sum of attribute A for all items selected from a relationship.