Trying to get a summary field through a portal

General support questions.
PostPosted: Sat Jun 11, 2005 12:17 pm
I need to get either the total of repeating fields in a portal to display locally, or get a summary field from that portal query to display? Can anyone help me with some ideas?
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Sat Jun 11, 2005 2:10 pm
Well I'm not completely sure what your situation is, but given a portal with a number field in it, you can sum that number fields by creating a new calc field like this:

Sum ( PortalRelationship::NumberField )

Aside from that, I'd just search FileMaker's built in help for "sum" and then read the first entry ("Sum function"). This discusses the case above as well as its application to repeating fields.

Best,

John
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: