Mode

 

Purpose:

Calculates the mode (most common value) of the set of values that result from the first parameter / formula.

Parameter:

Number       Expression for the value to be examined.

Boolean       (optional) The values which were stored for the calculation are deleted after output. (default: TRUE). Please note that the stored calculation values are generally deleted for every (sub)table end. The second parameter only decides whether the values are already deleted within the table.

Return value:

Number