AnsweredAssumed Answered

Calculation of Total under specific criteria per month

Question asked by Kaorin on Feb 27, 2014
Latest reply on Mar 4, 2014 by Kaorin

Title

Calculation of Total under specific criteria per month

Post

     Hello, 

     I wonder someone can let me know how to do the calculation of following "without" using summary fields / part:

     I'd like to get the TOTAL amount spent each month under Calculation field, and so far I have 

     - AMOUNT SPENT field (number)       and

     - MONTH (text) field  , Jan / Feb / Mar ...... Dec

     Is there anyway of using a calculation field and set criteria / function / formula so that I don't have to keep "sorting" to get the instant Amount Spent on each month under one Table?

     Say I'm trying to get the Total Amount Spent for March without using Summary fields & part. in a different Table as an Annual Report.

     It's ironic - I'm trying to set the Brows Mode of my Filemaker to look like Excel spreadsheet on this occasion! Please don't tell me to go back using Spreadsheet.

     I use FM 12 for Mac.

     Thank you.

      

      

      

      

Outcomes