1 Reply Latest reply on Jun 19, 2012 5:57 AM by philmodjunk

    Monthly

    RyanCourville

      Title

      Monthly & Yearly Billing

      Post

      Hey,

       

      I made a PO database and we want to implenament a way to see the monthly total and yearly total.

       

      What formula would I use, also how would I go about displaying them? I was thinking about a button but, after a year, I think I would have to reassign it to.

       

      Thanks,

       

      Ryan

        • 1. Re: Monthly & Yearly Billing
          philmodjunk

          What format for your report do you need?

          A list of all PO's grouped by Vendor with subtotals for each vendor? for each Month? For each vendor for each month?

          Or do you want a report that lists each item purchased and has similar subtotals?

          In either case you won't have formulas as such but instead you use summary fields that compute totals of fields in the same table. Then it's a matter of seeting up sub summary layout parts and putting the same summary field in different sub summary layout  parts to compute your monthly and other sub-totals--then sorting your records by the same "when sorted by" fields specified in your sub summary parts.

          Here's a tutorial on summary reports:  Creating Filemaker Pro summary reports--Tutorial