AnsweredAssumed Answered

Sum over a date range

Question asked by DirkAMS on Oct 19, 2009
Latest reply on Oct 19, 2009 by philmodjunk

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 

Outcomes