Difference in using SUM and COUNT

[#1]

Hi All

What is the difference in using SUM and COUNT?

Regards

Attitude

[mazacini]

Let's say you have 3 records, value 10, 20 and 30.

Sum will give you the sum of the values = 60

Count will give you the count of the records = 3

[its_anandrjs]

Hi Attitude,

Let Say You have different values and its values are 10,20,30. If you normal sum it it will be 60 but suppose the 20 value is distribute for different customer say. so if sum it it will different. Also see the sample file. And see difference between Distinct Sum, Distinct Count.

Anand

[its_anandrjs]

Hi Atitude,

Hope you got Correct Answer if you got please mark it as Correct Answer.

Anand