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

    Subsummary data in a portal

    k1ngf1sher

      Title

      Subsummary data in a portal

      Post

      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
          Marx
            

          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.