Analytics always performs the formula on each of the Features individually, then operates on the resulting values to generate the final result. Formulas follow order of operations.

Operations

Sum: Adds all feature results

Average: Averages the feature results

Minimum: Returns the smallest feature result

Maximum: Returns the largest feature result

Count: Counts the features

Constant: Does not operate on features. Returns the value typed into the formula bar.

Select the operation to perform on the resulting values in the Measure Builder

Example:

In this example, 2 geometries are passed into analytics.

The formula calculates hard cost. Hard cost is GBA * Hard Cost

The result of the measure depends on the selected Operation.

Sum: 39,587,950

Average: 19,793,975

Minimum: 10,620,232

Maximum: 28,967,718

Count: 2

Constant: ______________________________

Other Rules:

• Formulas follow order of operations
• Formulas accept the syntax defined in Formula Function List
• Formula text must be in ALLCAPS
• N/A values are treated as Null (not 0)