Not able to calculate sum of multiple column where file data in different format .csv | Linux |

I have a scenario where i want to calculate sum of column SAL|CAL|TAG|VAL 12.11″|”1.1″|”2.1″|”1.1 13.11″|”1.1″|”2.2″|”2.2 14.11″|”1.1″|”2.4″|”2.4 My below code not giving output giving output as 0.00 i need output for this column CAL VAL awk -F’|’ ‘{T+=$2} END { printf “%.2f\n”, T }’ demo.txt output : 6.7 5.7

Details