### 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.

Can't you set up a relationship based on dates ? So assume your current table is called expenditure and has two fields called expenditure_date and expenditure_amount . Have a second table called total expenditure with three fields called start of month , end of month and total expenditure . The relationship could be

expenditure:: expenditure date >= total expenditure :: start of month AND

expenditure::expenditure date <= total expenditure :: end of month

Then total expenditure::total expenditure = sum(expenditure amount). Thanks kaps