sum of portal records with patterncount

[Rasse]

I have portal with related records.In portal row record I need find specific text (patterncount) from a field and sum up that records cost field. How do i do that? Do I need to do a loop every portal row and use patterncount to check correct record and sum that record cost field($costs = $costs + table::cost)?

Thank you for your help.

[xochi]

Other ideas you could try:

• ExecuteSQL (not easy, but very powerful)
• Use the List() function with a recursive Custom Function
• If the pattern you are searching for is not the same as what the portal is showing you could also create a new, separate relationship using a calculated key which matched the pattern.