Portal calcs

[mhudd]

I have a main DB with a portal that displays "expenditures"

Is it possible to auto calc a running total for the portal on my main DB for "expenditures" and display it in a field outside of the portal?

[andygaunt]

Yep,

just create a field as a calculation

Sum(Relationship::number field to total)

Calculation result will be unstored.

One running total

quote:

---

Originally posted by Michael Huddleston:

I have a main DB with a portal that displays "expenditures"

Is it possible to auto calc a running total for the portal on my main DB for "expenditures" and display it in a field outside of the portal?

---

[mhudd]

Andy,

Actually what I meant to say was that each record on my main DB has a serial number and as I add new expenditures they are tied to the serial number of the record on the main DB.

I would like a running total of that particular records expenditures. Any ideas?

[signal]

Same thing. Use the relationship that the portal is based on and create a calculation field in the parent file that sums the related child records.