Summary of portal records by filtering

[lilwolfpro]

How do I the results from the portal so I can restrict results limited only to portal records shown? I am building a greyhound racing analysis software for fun and want to limit results. EX.

Main layout is Raceform, List 8 dogs in a race

Dog 1

Portal pulls in his average speed from Dog Stats database. (matched by dog name)

I have an inequitable relationship so the records pulled in the portal show his average speed of races run before the race date, sorted by date, most recent race first.

I have 9 portal rows showing, however my field in main layout (average calc formula )averages all his past races.

I want the average only to reflect his last 9 races. Any suggestions would be helpful-thanks.

[Lee Smith]

Just do a search of the forum for your keyword of race and you will find other post that will help you.'

To search the Forum, use the [color:blue] Search and choose the [color:blue] Advance Search Option.

Be sure the left side

Search = [color:green]All Forums

and the Right Side

Keywords = [color:green] Race

HTH

Lee

[comment]

Averaging related records takes into account ALL RELATED records. It doesn't matter how many visible rows a portal has.

If you want to limit the average to 9 most recent records, you will need a relationship that isolates them (i.e. ONLY these 9 records conform to the relationship's criteria).

See this thread for a possible approach.