1 Reply Latest reply on Aug 8, 2013 2:37 PM by philmodjunk

    the dreaded sumif

    wcallman

      Title

      the dreaded sumif

      Post

           Trying to make a database simplier than using excel. I am struggling with sumif. 

           database has the following fields

           catergory - text,  date-date, amount-(currently)number, supplier-text, reason-text.

           I want to create a seperate layout that has the total for each category, and another layout

           that totals each supplier. When I say total I am looking for the total of the "amount" entered.

           I have tried joined db's, portals, case, created a report layout which ran the totals just fine, but

           when I tried to bring the totals into another field using get, no success, so far no result (a correct one).

           In ex-ex-ex-excel  I can easily accomplish this using sumif. Has anyone created a solution? or work around?

           Thanks

           Bill Allman

        • 1. Re: the dreaded sumif
          philmodjunk

               Define a summary field to compute the total of amount.

               Create a new layout based on the table that you already have here.

               Use Part setup to add a sub summary layout part. Specify that the sub summary part be visible "when sorted by" your Category field.

               Put your new summary field into this new sub summary layout part.

               If you want to see just the totals for each category and not the indivdual records that make up each category, delete the body layout part.

               Return to browse mode and sort your records by the category field.

               You can also add a second sub summary layout part, put the same fields in it, but specify the supplier field as the break (when sorted by) field.

               If you sort your records by supplier, you see totals for each supplier. If you sort by category, you see totals for each category.