Add

Returns the sum of two or more values. The Add function differs from the Sum function (see Sum ), which returns the sum of values in a single value list. Add can take multiple metrics as inputs and add the values of the metrics.

You can also construct these types of metrics using the plus operator (see Plus (+)) instead of the Add function.

Syntax

Add(Argument1, Argument2,..., ArgumentN)

Where

The arguments must be metrics or constants.

Example

You can use the Add function to return the sum of related metrics. In the report shown below, the Total Paid Compensation metric uses the formula Add([Paid Bonus],[Paid Salary]) to return the total compensation paid to each employee. This report was created in the MicroStrategy Human Resources Analysis Module.