Hi All,
I need to calculat the sum of the particular field in text file. And the datatype of the field in file is decimal(18,2). If the file is small, then I am facing any problem. But the file is huge, then the result is converted into exponential format.
I tried using various command thr this forum, but still facing the problem.
AMOUNT=`orchadmin dump -field AMOUNT $1/$2 | awk '{sum+=$1} END {printf("%.2f",sum)}'`
Thanks in advance.