Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

absolute sum

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting absolute sum
# 1  
Old 05-19-2011
absolute sum
Code:
Hi,
i want to caluculate sum and absolute sum information of the 2nd column.

sum(abs(ENO)),sum(ENO)

file1 contains the employee information.

"abc","+10000.00","100"
"bbc","-3000.00","400"
"cbc","+20000.90","500"
"dbc","-4000.00","600"

output should get this 

Sum(abs(eno))    sum(eno)          
----------- -----------
37000.90       23000.90


i am getting sun value but i am unable to get the information on the sum of abs values. 

Any help greatly appriciated. 
Thanks

Last edited by onesuri; 05-20-2011 at 01:52 AM..
# 2  
Old 05-19-2011
Please, show your code.
# 3  
Old 05-20-2011
Here are the detailed information.

Sample data from the file_name.txt:
-30.1932871983700
-40.1149000000
+60.2300
+20.0012389018230123
-
-
so on

Code:
awk '{ Val += $1; AbsVal += ($1>=0?$1:(0-$1)) } END {printf("Value = %d\t Abs Value = %d\n", Val, AbsVal)}' file_name.txt

Command output: Sum and abs sum values are not coming properly.

Value = 18426854789.828552 Abs Value = 120707557235749.953125
i should get the below values.

Value =18426854789.85 Abs Value = 120707557235749.96

based on the fours i have tried this command but decimal values are not coming properly.

any help greatly appriciated.
thanks
# 4  
Old 05-20-2011
Code:
nawk -F, -v qq='"' '{gsub(qq,"");s+=$2;sa+=($2<0)?-$2:$2}END{print sa, s}' OFMT='%.2f' myFile

# 5  
Old 05-20-2011
sa+=($2<0)?-$2:$2
could also be
sa+=sqrt($2^2)
These 2 Users Gave Thanks to ctsgnb For This Post:
danmero vgersh99
# 6  
Old 05-20-2011
Quote:
Originally Posted by ctsgnb
Code:
sa+=($2<0)?-$2:$2

could also be
Code:
sa+=sqrt($2^2)

Just another smart way to solve a problem Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to use absolute function?

Hello All, I am using following awk command in my shell script. I want to compare the value in column 2 and colum 3 after taking their absolute value. Column $2 and $3 can have any value positive or negative or both. awk -F"|" '{print $0,($2>$3?"F":"T")}' OFS='|' myfile.txt Your help... (2 Replies)
Discussion started by: angshuman
2 Replies

2. Shell Programming and Scripting

Sort by absolute value

Hi, I have a file as follows: |-30.0|Appls. executing in db manager currently = 2 |-80.0|Locks held currently = 1 | 90.0|High water mark (bytes) = 65536 |-50.0|Configured size (bytes) = 16777216 |-100.0|Current size (bytes) ... (6 Replies)
Discussion started by: sudvishw
6 Replies

3. Shell Programming and Scripting

Print sum and relative value of the sum

Hi i data looks like this: student 1 Subject1 45 55 Subject2 44 55 Subject3 33 44 // student 2 Subject1 45 55 Subject2 44 55 Subject3 33 44 i would like to sum $2, $3 (marks) and divide each entry in $2 and $3 with their respective sums and print for each student as $4 and... (2 Replies)
Discussion started by: saint2006
2 Replies

4. UNIX for Dummies Questions & Answers

absolute value

is there any function in unix which will convert a integer to absolute value with a single decimal point. suppose x=15232 y=x/1024=14.875 i want y to be 14.8 Similarly if y=6.29452 it should come as 6.3 (3 Replies)
Discussion started by: dr46014
3 Replies

5. Shell Programming and Scripting

Absolute value

Is there a function in awk to get the absolute value of a-b which can be negative or positive, I just care for the absolute value... (5 Replies)
Discussion started by: placroix1
5 Replies

6. UNIX for Dummies Questions & Answers

absolute path

is cd ~ considered an absolute path? (2 Replies)
Discussion started by: Kirichiko
2 Replies

7. Shell Programming and Scripting

get absolute filename

How would I get the absolute filename of a selected file...I want to control click...I already have the context menu all set to run a script...I just need to be able to get the file name of the file I control clicked on. In windows it is as follows: set filename=%~f1 set name=%~n1 set... (0 Replies)
Discussion started by: mainegate
0 Replies

8. Programming

absolute path

How to find out the absolute path of a file in C/C++? Thanks (4 Replies)
Discussion started by: filedeliver
4 Replies

9. UNIX for Dummies Questions & Answers

Getting absolute value ksh

Hi, I am trying to find out how to get an absolute value for integer in ksh. I tried using abs... but that doesn't work ! this is the workaround I did, but isn't there an inbuilt function to get absolute value for any variable ! Please help as i am new to unix :confused: Thanks, ... (3 Replies)
Discussion started by: icyhot
3 Replies
Login or Register to Ask a Question