# Simple Calculation Functions and Operators

 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).