sum IN FIELD

[#1]

Hi ,

the field !"A" icontains 3 rows :

100

50

-50

I would the sum of this field (100) in a new field .

I tried:

numsum(A) as second Field

but do noy work

Thanks

Sl

[prieper]

Why would you want to do?

Peter

[#3]

I have 3 fields:

Entry Group no : 600

Entry no: 100,200,101

amount: 100,50,-50

Entry Group no : is linked to 3 Entry no: and also the value of this entries (amount)

I woyld to have the total (sum of amount) of Entry Group no

thanks

Best regards

Sl

[prieper]

Still not quite clear to me, in a script you may achieve this by
LOAD [Entry Group no], SUM(amount) FROM .... GROUP BY [Entry Group no]
in a straight table just take [Entry Group no] as dimension and enter SUM(amount) as expression

Peter

[#5]

No,no ..

I would get the result in RUNTIME

I tried sum and group by but I woyld get Total Amount in Field

ILoad a,b, sum(amount) as total Group by(a,b, amount; Sql Select ...

the new field total is the total; in this case 100

( 100-50+50)

I would the t"total" field contains 100 like value

Sl

[#6]

I solved. The group by is used Just a dimension not a expression.

Thanks

Best Regards

Slash