can any one tell me difference between aggregation and range sum?

[#1]

plz any one share the answer..........

[alexandros17]

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

[#3 · Accepted solution]

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.

[maternmi]

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