Awk total and variance

Shell Programming and Scripting
1

File1

 
0358 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd    (M) RW  102413
0359 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
035A Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
035B Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
035C Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   27641
035D Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   27641
035E Not Visible            ***:* 09B:D10 2-WayMir     N/Grp'd       WD    8632
035F Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd        RW   30720
0360 Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   28665
0361 Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   29689
0362 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd        RW   30713
0363 Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   46069
0364 Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   46069
0365 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd    (M) RW  256031
0366 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
0367 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
0368 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
0369 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036A Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036B Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036C Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036D Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036E Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
03F7 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd        RW   40950
0411 Not Visible            ***:*  NA:NA  TDEV          N/Grp'd  (M) RW  706562

File2

 
0358 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd    (M) RW  102413
0359 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
035A Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
035B Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
035C Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   27641
035D Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   27641
035E Not Visible            ***:* 09B:D10 2-WayMir     N/Grp'd       WD    8632
035F Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd        RW   30720
0360 Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   28665
0361 Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   29689
0362 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd        RW   30713
0363 Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   46069
0364 Not Visible            ???:?  NA:NA  BCV+TDEV      N/Asst'd     NR   46069
0365 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd    (M) RW  256031
0366 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
0367 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
0368 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
0369 Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036A Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036B Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036C Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036D Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
036E Not Visible            ***:*  NA:NA  RDF1+TDEV     N/Grp'd  (m) RW       -
03F7 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd        RW   40950
0411 Not Visible            ***:*  NA:NA  TDEV          N/Grp'd  (M) RW  706562
0416 Not Visible            ***:*  NA:NA  TDEV          N/Grp'd  (m) RW       -
041A Not Visible            ???:?  NA:NA  TDEV          N/Grp'd  (M) NR  102413
041B Not Visible            ???:?  NA:NA  TDEV          N/Grp'd  (m) NR       -
041C Not Visible            ???:?  NA:NA  TDEV          N/Grp'd  (m) NR       -
041D Not Visible            ???:?  NA:NA  TDEV          N/Grp'd  (m) NR       -
041E Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd        RW   40950
0456 Not Visible            ***:*  NA:NA  RDF1+TDEV     Grp'd    (M) RW  102413

Output

RDF1+TDEV  30 TB( +2%) 
2-WayMir   10 TB( -2%)
BCV+TDEV   15 TB( +0%)
TDEV       11 TB( +1%)

Output file is total in Terabytes rounded off ( last column of files is in MB ) , grouped by 6th field type and shows the variance rounded off ( % increase or decrease ) from file 1
If there is no change then 0%
Thx

2

Try:

awk 'NR==FNR{a[$6]+=$NF}NR!=FNR{b[$6]+=$NF}END{for (i in a){printf "%s\t%.2f TB( %+d%)\n",i,b/(1024*1024),(b-a)/(a*0.01)}}' file1 file2
3

Thanks Bartus .... works fine