Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
plz any one share the answer..........
Aggregation is used to aggregate values across different dimensions.
Eg: Aggr(Sum(Sales),Month,Country)
Sales is aggregated at Month and Country level.
RangeSum is used to calculate sum of range of values.
Eg: Rangesum(1,5,10) gives 1+5+10=16
Rangesum(Above(Sum(Sales),0,5) returns sum(Sales) of above 5 rows from the current row.
Range sum return the sum of more values, it is useful because automatically discard null or strings so:
Rangesum(1,4,null(), 'ANC') returns 5
Aggr function is a completely different function, it aggregates more values with the same value
Aggregation is used to aggregate values across different dimensions.
Eg: Aggr(Sum(Sales),Month,Country)
Sales is aggregated at Month and Country level.
RangeSum is used to calculate sum of range of values.
Eg: Rangesum(1,5,10) gives 1+5+10=16
Rangesum(Above(Sum(Sales),0,5) returns sum(Sales) of above 5 rows from the current row.
Hi,
rangesum:
Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0.
aggregation sum:
Returns the sum of expression over a number of records as defined by a group by clause. If the word distnict
occurs before the expression, all duplicates will be disregarded.
hope that helps you.
BR