AnsweredAssumed Answered

summary by date

Question asked by buck_5648798798 on May 12, 2010
Latest reply on May 13, 2010 by buck_5648798798

Title

summary by date

Post

I'm using FM 10, Mac 10.6.3

 

I'm working on an invoice system and I want to see how much was earned by month.

 

I have a simple layout with Work Date, Total $ and a summary field that adds it all up.

 

If I do a find for "2/*/10" I'll get February's total so that is ok, but clunky.

 

Is there a way to create a calculation field for each month that does this for me? Something like "total february = (mysummaryfield) within a date range (2/1/10-2/28/10)"

 

Thanks

Outcomes