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 DEBIAN

zlanht

zlanht.f(3)							      LAPACK							       zlanht.f(3)

NAME

       zlanht.f -

SYNOPSIS

   Functions/Subroutines
       DOUBLE PRECISION function zlanht (NORM, N, D, E)
	   ZLANHT

Function/Subroutine Documentation
   DOUBLE PRECISION function zlanht (characterNORM, integerN, double precision, dimension( * )D, complex*16, dimension( * )E)
       ZLANHT

       Purpose:

	    ZLANHT  returns the value of the one norm,	or the Frobenius norm, or
	    the  infinity norm,  or the  element of  largest absolute value  of a
	    complex Hermitian tridiagonal matrix A.

       Returns:
	   ZLANHT

	       ZLANHT = ( max(abs(A(i,j))), NORM = 'M' or 'm'
			(
			( norm1(A),	    NORM = '1', 'O' or 'o'
			(
			( normI(A),	    NORM = 'I' or 'i'
			(
			( normF(A),	    NORM = 'F', 'f', 'E' or 'e'

	    where  norm1  denotes the  one norm of a matrix (maximum column sum),
	    normI  denotes the	infinity norm  of a matrix  (maximum row sum) and
	    normF  denotes the	Frobenius norm of a matrix (square root of sum of
	    squares).  Note that  max(abs(A(i,j)))  is not a consistent matrix norm.

       Parameters:
	   NORM

		     NORM is CHARACTER*1
		     Specifies the value to be returned in ZLANHT as described
		     above.

	   N

		     N is INTEGER
		     The order of the matrix A.  N >= 0.  When N = 0, ZLANHT is
		     set to zero.

	   D

		     D is DOUBLE PRECISION array, dimension (N)
		     The diagonal elements of A.

	   E

		     E is COMPLEX*16 array, dimension (N-1)
		     The (n-1) sub-diagonal or super-diagonal elements of A.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   November 2011

       Definition at line 102 of file zlanht.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.1							  Sun May 26 2013						       zlanht.f(3)
All times are GMT -4. The time now is 03:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy