3 Replies Latest reply on Aug 12, 2009 5:33 AM by mrvodka

    GetSummary

    Jubin

      Title

      GetSummary

      Post

      Hi there,

                  Am a newbie 2 filemaker. Could anyone pls tell me how to use the GetSummary function with an example. Thanks in advance.

        • 1. Re: GetSummary
          mrvodka
            

          GetSummary () works very much the same like a normal summary field in a sub-summary report. You can use a calc with GetSummary (), to display in browse mode but you work still have to sort the found set, and specify the break field just like a subsummary report.

           

           

           

          • 2. Re: GetSummary
            Jubin
              

            Would u mind suggesting an example?

            • 3. Re: GetSummary
              mrvodka
                

              Lets say you have 3 fields.

              Color ( text )

              sCount ( summary: count )

              cGetSum ( calculation: GetSummary ( sCount; Color )

               

               

              Now if you have 7 records

              Red

              Green

              Blue

              Blue

              Red

              Green

              Green

               

               

              Now sort the records ( it will result like such when Ascending ).

              Color         cGetSum

              -------------------------

              Blue             2

              Blue             2

              Green           3

              Green           3

              Green           3 

              Red              2

              Red              2