1 Reply Latest reply on Aug 13, 2010 9:40 AM by philmodjunk

    How to sum found records?

    zhgchen

      Title

      How to sum found records?

      Post

      example, I have table looks like:

      Company | Region | Revenue

      Sap          | EMEA   |   12

      Oracle      | EMEA   |   22

      Sap          | APJ      |   12

      Under find mode, if I perform search with Region = "EMEA"

      Sap          | EMEA   |   12

      Oracle      | EMEA   |   22

      above 2 records will be found, I want to summarize Revenue based on above 2 found records in a layout field

        • 1. Re: How to sum found records?
          philmodjunk

          Define a summary field with the total of option and select the revenue field.

          Best place to display this field is in the Header, footer or a grand summary part, though you can place it in the body if you want to show the total over and over, you can even set it up to display a running total if you want.

          Place this field in a sub summary part and you can also get subtotals for groups of records.