Sum

Returns the sum of the values in a list of values. The function adds together all numbers in the value list and returns the total. This is a group-value function.

Syntax

Sum<Distinct = False, FactID, UseLookupForAttributes(Argument)

•  

• Distinct is a true/false parameter that allows you to calculate using all values in the list or only the unique values.

• FactID is a parameter that forces a calculation to take place on a specific fact table containing the FactID.

• Argument is an attribute, fact, or metric representing a list of numbers.

• UseLookupForAttributes is a TRUE/FALSE parameter that can be used when performing an aggregation of an attribute. The Count function is most commonly used to aggregate attributes. For information on this parameter, including an example of using it with the Count function, refer to the Functions Reference.

For additional information on and an example of this function, refer to the Functions Reference.