script/calculation : total whith another field = XXX

[yaron]

Hi.

I want to have a certain summary field in a record/table

the summary should be like the sum of all records's field "amount" where field "deal_id" equals that record's "deal_id" field.

I couldn't find how to do so in the basic sumary field options.

thanks for your help, it is really important.

yaron.

[aldipalo]

Can you be a little more descriptive. Exactly what are you trying to do?

[John Mark Osborne]

Sounds like you want an Aggregate function like Sum. The Sum function allows you to add up records across a relationship. For example, you could total all the related records you see in a portal using this function. So, if you have a parent table related to child records, make the following formula in the parent table:

Sum(Child::Number)

[yaron]

thanks but can I do it in the same table?

[John Mark Osborne]

Use a self-join relationship. Just make a new table occurrence using the same base table and relate the two based the deal_id field.