SumOn (MDX)
Returns the sum of each value of the first vector defined by the second vector positions.
Parameters
| Name | Type | Cardinality | Default value |
| vector-expression | one | ||
| vector-expression | one |
Return
value
Description
Returns the sum of each value of the first vector defined by the second vector positions.
SumOn ( V1, V2 ) = ForEach( V2i -> V2 ; sum += V1( V2i ) )
A standard scenario for this function is defining V1 as a static function that contains the values we want to
aggregate and V2 as a measure with a vector unique aggregation type.
See Also
Examples
Special Examples (errors, null, ...)
Since Version
6.0.3
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.