Can anyone tell me how sum values in each record of a file and append that value to the end? For instance a typical record will be:

FY12,Budget,771100,,,,,,,,,250,-250

FY12,Budget,771100,,,,,,,,,250,-250,0

awk -F, '{for(i=4;i<=NF;i++){s+=$i}{$(NF+1)=s}}1' OFS="," file

or:

awk -F, 'BEGIN{OFS=","}{for(i=4;i<=NF;i++)s+=$i;print $0,s}' infile > another_file

Thank you both very much for the quick response!

Both code sets worked great but what I neglected to mention is that the file has many records and I need to sum record by record and not carry the total.

try this

awk -F, '{for(i=4;i<=NF;i++){s+=$i}{$(NF+1)=s;s=0}}1' OFS="," file

Simply amazing! Thank you Pamu!!!

awk -F "," ' { for( Cnt=NF-1; Cnt<=NF ; Cnt++) { Val+=$Cnt ; }
print $0","Val ;

} ' In_File_Name >> Out_File_Name