Simple Calculation Functions and Operators
A calculated field added to an Analytics Report can contain both functions and operands to create the formula.
Function 
Icon 
Description 
Count 
Count the number of items 

Count Distinct 
Count the number of items that are distinct 

Sum 
Add the values 

Average 
Calculate the average value 

Minimum 
Use the minimum value 

Maximum 
Use the maximum value 
Operator 
Icon 
Description 
Add 
Perform addition 

Subtract 
Perform subtraction 

Multiply 

Perform multiplication 
Division 
Perform division 

Open Parenthesis 
Insert open parenthesis – the formula inside parentheses is performed first 

Close Parenthesis 
Insert close parenthesis – the formula inside parentheses is performed first 

Case 
Select if you want to set up an If…then statement. The When, Else, and End options are enabled to create the statement. 

When 
Defines the condition that must be met (i.e., WHEN), and also defines the THEN result to establish what should be returned by the calculation when the WHEN condition is met. 

Else 
Defines what should be returned by the calculation if none of the WHEN conditions are met. 

End 
Select to end the conditional calculation (If…then statement). 