How to sum up two decimal values? Post: 302458608

Sponsored Content

Top Forums Shell Programming and Scripting How to sum up two decimal values? Post 302458608 by methyl on Friday 1st of October 2010 08:15:29 AM

10-01-2010

Registered User

Looks like a little logic error to me.
The variable ${final_amount} is being zeroised on every iteration.
We should move to to outside the loop.
The arithmetic line is faulty in logic (adding the wrong variable) and syntax (expr can't deal with decimal places). You presumably want to add ${amount} to ${final_amount} on each iteration.
Also, without knowing what Shell you are using it is hard to be sure whether the updated variable is available outside the loop.

Code:

final_amount=0
cat ind_sls_extr_UX.out_sorted | while read each_rec
do
  count=`echo "${each_rec}" | cut -c1-2`
  if [ ${count} -eq 45 ]
  then
       amount=`echo "${each_rec}" | cut -c280-287`
       echo "${amount}"
       final_amount=`echo "${final_amount} + ${amount}"|bc`
  fi
done

Last edited by methyl; 10-01-2010 at 09:23 AM.. Reason: layout & include Michaelrozar17's maths idea - rewritten and corrected

methyl

View Public Profile for methyl

Find all posts by methyl

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Converting Binary decimal coded values to Ascii Values

Hi All, Is there any command which can convert binary decimal coded values to ascii values... i have bcd values like below ��0�-- -v - Pls suggest a way to convert this. Thanks, Deepti.Gaur

2. Shell Programming and Scripting

print decimal values

Hi guys I'm trying to print average of 2 columns. awk '{print ($1+$2)/2}' file.txt Its printing average but not giving decimal values its giving 3.05521e+08 instead of 305521.... I tried %f to print float values but not quiet connected Could you help plz:confused:

3. UNIX for Dummies Questions & Answers

Sum up a decimal column in a tab separated text file and error handling

Hi, I have a small requirement where i need to sum up a column in a text file. Input file 66ab 000000 534385 -00000106350.00 66cd 000000 534485 -00013364511.00 66ad 000000 534485 -00000426548.00 672a 000000 534485 000000650339.82...

4. Shell Programming and Scripting

Sum of decimal numbers in column

Hi!!! I have n decimal numbers in column: 1.23 3.45 5.16 . . . How to do arithmetic sum of theese numbers??? Thanks!!!:D

5. Shell Programming and Scripting

How to get decimal values ?

Hi All, In my script I've written like this- c=$( expr 100 / 3);echo $c The output coming is 33. but I want to see 33.33, decimal values too. How to get that? Thanks, Naresh

6. Shell Programming and Scripting

Rounding off decimal values

Hi Friends, This is my last post for today. My input file is chr1 100 200 chr1 123 300 chr1 300 400 chr1 420 520 chr10 132344343 132348674 When I try using this command awk '{v=($3+$2)/2; print $0"\t"v}' 1 This is my output chr1 100 200 150 chr1 123 300 211.5

7. Shell Programming and Scripting

How compare decimal values?

I have 2 files say tp1.txt and tp2.txt having following data cat tp1.txt abc,2.20,IN20 acb,3.15,DN10 bca,3,RD10 cat tp2.txt alv,1.00,IN20 aaa,4.05,DD10 abb,5.50,RD12 i want to compare the values on 2nd field of both the file, if value of first tp1.txt is greater than value...

8. Post Here to Contact Site Administrators and Moderators

How to sum up data in fixed width file with decimal point?

9. Shell Programming and Scripting

Sum the fields with 6 decimal places - getting only 2 decimal places as output

I used the below script to Sum up a field in a file based on some unique values. But the problem is when it is summing up the units, it is truncating to 2 decimals and not 6 decimals as in the input file (Input file has the units with up to 6 Decimals – Sample data below, when the units in the 2...

LEARN ABOUT OPENSOLARIS

sum

sum(1B) 					     SunOS/BSD Compatibility Package Commands						   sum(1B)

NAME

       sum - calculate a checksum for a file

SYNOPSIS

       /usr/ucb/sum file...

DESCRIPTION

       sum  calculates	and  displays a 16-bit checksum for the named file and displays the size of the file in kilobytes. It is typically used to
       look for bad spots, or to validate a file communicated over some transmission line. The checksum is calculated by an  algorithm	which  may
       yield different results on machines with 16-bit ints and machines with 32-bit ints, so it cannot always be used to validate that a file has
       been transferred between machines with different-sized ints.

USAGE

       See largefile(5) for the description of the behavior of sum when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWscpu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       sum(1), wc(1), attributes(5), largefile(5)

DIAGNOSTICS

       Read error is indistinguishable from EOF on most devices; check the block count.

NOTES

       sum and /usr/bin/sum (see sum(1)) return different checksums.

       This utility is obsolete.

SunOS 5.11							    8 Nov 1995								   sum(1B)

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Converting Binary decimal coded values to Ascii Values

Discussion started by: gaur.deepti

2. Shell Programming and Scripting

print decimal values

Discussion started by: repinementer

3. UNIX for Dummies Questions & Answers

Sum up a decimal column in a tab separated text file and error handling

Discussion started by: pssandeep

4. Shell Programming and Scripting

Sum of decimal numbers in column

Discussion started by: tdev457

5. Shell Programming and Scripting

How to get decimal values ?

Discussion started by: NARESH1302

6. Shell Programming and Scripting

Rounding off decimal values

Discussion started by: jacobs.smith