1 Reply Latest reply on Oct 19, 2009 10:29 AM by philmodjunk

    Sum over a date range

    DirkAMS

      Title

      Sum over a date range

      Post

      Hi there,

       

      I am using FMP10 on Snow Leopard. I have built a standard database that helps me keeping track of my company administration. This database has a number of linked tables and it works fine.

       

      Now I would like to create an overview that shows - by quarter and year - the total received payments (from the received payments table) and the total taxes paid (from the expense table)

       

      In the layout that I want the summary in (different table), I have made a variable "month".

       

      I was trying Sum(     Case( Expenses::Month=Month;  Expenses::Tax Reimbursable;"" )   )  This unfortunately did not work

       

      Thanks very much in advance!

      Dirk 

        • 1. Re: Sum over a date range
          philmodjunk
            

          In your post you state that you want the totals by "Quarter and Year", but you calculation example references a "month" field that you do not describe. What exactly do you want? by "Quarter and Year" with a monthly sub-total break down within each quarter?

           

          Do we have three tables here? (expense, payments and "different table")

           

          What are the relationships you have in place linking these?