Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: absolute sum
Top Forums Shell Programming and Scripting absolute sum Post 302523668 by onesuri on Thursday 19th of May 2011 10:26:54 AM
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..
 

9 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. UNIX for Dummies Questions & Answers

absolute path

is cd ~ considered an absolute path? (2 Replies)
Discussion started by: Kirichiko
2 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 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

7. 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

8. 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

9. 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

LEARN ABOUT OPENSOLARIS

sum

sum(1)								   User Commands							    sum(1)

NAME

       sum - print checksum and block count for a file

SYNOPSIS

       sum [-r] [file]...

DESCRIPTION

       The   sum utility calculates and prints a 16-bit checksum for the named file and the number of 512-byte blocks in the file. It is typically
       used to look for bad spots, or to validate a file communicated over some transmission line.

OPTIONS

       The following options are supported:

       -r    Use an alternate (machine-dependent) algorithm in computing the checksum.

OPERANDS

       The following operands are supported:

       file    A path name of a file.  If no files are named, the standard input is used.

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).

ENVIRONMENT VARIABLES

       See environ(5) for descriptions of the following environment variables that affect  the	execution  of	sum:  LC_CTYPE,  LC_MESSAGES,  and
       NLSPATH.

EXIT STATUS

       The following exit values are returned.

       0     Successful completion.

       >0    An error occurred.

ATTRIBUTES

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

       +-----------------------------------------------------------+
       |      ATTRIBUTE TYPE		    ATTRIBUTE VALUE	   |
       |Availability		      SUNWesu			   |
       |CSI			      Enabled			   |
       +-----------------------------------------------------------+

SEE ALSO

       cksum(1), sum(1B), wc(1), attributes(5), environ(5), largefile(5)

DIAGNOSTICS

       Read error is indistinguishable from end of file on most devices. Check the block count.

NOTES

       Portable applications should use cksum(1).

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

SunOS 5.11							    7 Nov 1995								    sum(1)
All times are GMT -4. The time now is 03:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy