4 Replies Latest reply on May 13, 2010 12:47 PM by buck_5648798798

    summary by date

    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