scripting

[Anonymous]

Hi all 

this is the data which i have

name	no.
abc	45
ddd	130.5
eee	22
rrr	12
ttt	9
yyy	2.4
bbb	1

i need output (sum of no.)

name	no.	output
abc	45	221.9
ddd	130.5	221.9
eee	22	221.9
rrr	12	221.9
ttt	9	221.9
yyy	2.4	221.9
bbb	1	221.9

i want to achieve this in script

regards

[felipedl · Accepted solution]

Hi kulwant,

Say you have the table:

Data:

Load

     name,

     no.

From [Whatever];

join (Data)

Load

     sum(no.) as Sumation

resident Data;

That will put the total sum at every row of your data.

Felipe.