6 Replies Latest reply on Aug 5, 2013 10:07 AM by AaronNutter

    GetSummary Issue



      GetSummary Issue


           Hi. I am making a database that includes a table that needs to keep records of deposits based on a bank id number and sum them up for a balance. I have fields Bank ID, Deposit, Balance, and Total. My idea is to make Total a summary field equal to Total of Deposit. Then I want to make Balance = GetSummary ( Total ; Bank ID). I had this working for a while and it worked exactly how I wanted it to. Now for some reason it does not work, and I cannot get it to work again. I have even tried making sample new databases to test it out and cannot get this function to work at all. Balance is just a blank field. Any help please?

        • 1. Re: GetSummary Issue

               To possibilities to check:

               The records being totaled must be present in the current found set and they must be sorted by Bank ID.

               Don't specify the running total option for Total. If you need a running total for other purposes, define two summary fields, one with the running total specified and one without.

          • 2. Re: GetSummary Issue

                 Thanks for the reply!

                 Yeah, the records are present and have a Bank ID in each. Running total is not checked.

            • 3. Re: GetSummary Issue

                   Is Balance a calcluation field or a number field with an auto-entered calculation?

                   It should be a field of type calculation and should be set up as Unstored by clicking the storage options button in the specify calculation dialog.

              • 4. Re: GetSummary Issue

                     It is a calc with unstored data. I have entered everything exactly as I have seen in examples, but no matter what I put in for sample data, the calculation for the balance always remains blank. 

                     In order to get what I need, I did manage to get a working subsummary area, but i still would really like to be able to use the getsummary function, as it is much easier to set up without having to use the sort function.

                • 5. Re: GetSummary Issue

                       "Sort function"? GetSummary only works with sorted found sets. You still have to sort your records. If it is not sorted by the Break field you use as the break field parameter, you get an empty result.

                  • 6. Re: GetSummary Issue

                         Thank you very much. I did not realize that the getsummary function had to be sorted by the break field. I thought it just automatically did that. That fixed everything. Thanks again!