summing field values in a portal

[hassam36]

Hi

I have a portal on a layout that has a dollar amount field and a "cost center" field in it among others.

I would like to include another field that sums the dollar amount field for all records that have the same cost center value.

I did this previously using a portal sort equal to the cost center field, a summary field for each record, and used a GetSummary() function that had a breakField equal to the cost center field. However, this no longer functions because I had to change the portal to reflect a second instance of the underlying table.

Does anyone know of another way to achieve this?

John

[bcooney]

Yes, create a sub-summary report by Cost Center in the table upon which the portal is based.

[hassam36]

How will creating a sub-summary report allow me to populate a summary field in the portal on my layout though?

John

[bcooney]

It doesn't. You asked for another way to achieve "this" and by "this" I thought you meant amounts by cost center.