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

Sum the fields with 6 decimal places - getting only 2 decimal places as output
# 1
02-15-2018
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 rows below highlighted in red are added, I only get 2 decimal places 18.34).

 Please use CODE tags as required by forum rules!

Last edited by RudiC; 02-15-2018 at 06:06 PM.. Reason: Added CODE tags.
 brlsubbu View Public Profile for brlsubbu Find all posts by brlsubbu
# 2
02-15-2018
Welcome to the forum.

This User Gave Thanks to RudiC For This Post:
 RudiC View Public Profile for RudiC Find all posts by RudiC
# 3
02-15-2018
This User Gave Thanks to rdrtx1 For This Post:
 rdrtx1 View Public Profile for rdrtx1 Find all posts by rdrtx1
# 4
02-21-2018
Sum the fields with 6 decimal places - numbers with all zeroes after the decimal is truncated

Thank you for your help. this really works in terms of adding.

But, I have a new problem where if it is all zeroes after the decimal, then it truncated.

for example, if the value is 4.000000, then the result I get is 4.

But I want the output to be 4.000000

Quote:
Originally Posted by RudiC
Welcome to the forum.

 brlsubbu View Public Profile for brlsubbu Find all posts by brlsubbu
# 5
02-21-2018
 vgersh99 View Public Profile for vgersh99 Find all posts by vgersh99

Test Your Knowledge in Computers #631
Difficulty: Medium
iPhone OS 1.0 was first released with great fanfare during the US Super Bowl in 2007.
True or False?

Calculate the constant e to 14+ decimal places using integer maths.

Hi guys... I am loving this integer maths thing. 64 bit systems are certainly easier than 32 bit, but hey, I don't intend to leave out my fav' platform. Using one of the 'Brothers' methods, URL inside the code. #!/bin/sh # # #!/usr/local/bin/dash # e_constant.sh # Brother's formula . #...

Printing with decimal places from last 4 digits

I have input file like below, 201424|9999|OSS|622010|RGT|00378228764 201424|8888|OM|587079|RGT|00284329675 201424|7777|OM|587076|RGT|00128671024 201424|6666|OM|581528|RGT|00113552084 Output should be like below, should add decimal (.) from last 4 digits. ...

How to round up value upto 2 decimal places using sed?

Please help me in rounding up value upto 2 decimal palces using sed command #!/usr/bin/bash a=15.42 b=13.33 c=`echo \$a*\$b |bc -l` echo \$c above code is is giving output "205.5486" but i want the output as "205.55" Thank you...

Bash Rounding to 2 decimal places

I have a number in a bash variable n, and want to round it to 2 decimal places. How can I do that? n=0.0867268 Need to have num=0.09

Arithmetic but keep 2 decimal places

I am trying to perform arithmetric, for example, to increment the value of variable \$a (say 3) by 0.05 but when I tried the following expression let a=a+0.05 or a=\$((a+0.05)) both returned 3.0499999999999998 I want to keep 2 decimal places so it returns 3.05 instead.

Decimal places

i need to multiplay a number with 1.00.. so that the output should contain two decimal places at end.. for example... 236 * 1.00 = 236.00 245.8 * 1.00 = 245.80 but when i perform multiplication it shows output as. 236 245.8 can anyone help me to get the actual output of...

Four decimal places with awk

i have a script in which awk prints "(\$2-1700)/10000" and the answer is -0.07,but i want the answer in 4 decimal places. that is -0.0700. How can i sue awk to get my results in four decimal places

Using the "Less Than" (-lt) switch on numbers with decimal places?

I'm using shell scripts to run some commands for the Configuration Management tool called Telelogic Synergy. I need to get the script to compare version numbers of files. The version numbers of the files are part of the actual filename, such as the following example: example_file-1...

trimm up the decimal places in output

I have a perl script that reports the avg time of a application call and the total number of calls. This works fine, however I would like to trim the number of decimal places reported from 12 to like 3 and I don't know how. Any suggestions? Here is what I use to get the avg time... for \$eRef (...