Get record count also along with SUM.

[Suntles Singh]

Hi,

I know tha tusing SUM FIELDS I can sum the values in an input file in sort but how can I get the count of the fields too which are summed up? For example, if my input is like this:

Code: Select all

ABC 250 
ABC 150 
EFG 700 
EFG 100
EFG 100 
EFG 050

The output should look like:

Code: Select all

ABC 400 2 
EFG 950 4 

Please let me know if there is a way to achieve this?

[Akshya Chopra]

viewtopic.php?f=28&t=2383

[Suntles Singh]

Thank you so much.