Subsummary data in a portal
Hi all, I've asked this before, but never received a response:
Is it possible to use subsummary report results in a portal? I did not think it was possible, hence my attempt to summarize information directly in table (if curious, see: http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&thread.id=41392)
I would appreciate learning any brainstorms on this question.
You can use most normal summary fields - those that depend on a sort order "Fraction of total, etc." cannot be referenced.
Of course, relational referential integrity will be enforced - i.e. if the relationship is there then the sum, avg, etc. will be allowed - but you usually have to add a downstream relationship from the portal table occurrence to get the right value.