Page 1 of 1

Get record count also along with SUM.

Posted: Wed May 03, 2017 11:52 am
by 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?

Re: Get record count also along with SUM.

Posted: Wed May 03, 2017 1:38 pm
by Akshya Chopra

Re: Get record count also along with SUM.

Posted: Wed May 03, 2017 1:42 pm
by Suntles Singh
Thank you so much. :)