1 Reply Latest reply on Feb 12, 2010 12:36 PM by Marx

    Subsummary data in a portal



      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.

      Thanks, K

        • 1. Re: Subsummary data in a portal

          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.