Jump to content

Monthly totals report?


This topic is 5782 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm a newbie and thanks for you help. I need to make a report with the monthly totals of the records. All the records have a date and an amount that I need to group by month. I only need to see the monthly totals, for example...




I've tried to make a summary report it has a subsummary sorted by date part which i put the date field and the amount field into but it does not total by month. It shows like 20 Octobers followed by 25 novembers, etc;... please help.

Link to comment
Share on other sites

Greetings Nina,

You'll need a Month field to break by. I'd suggest either having a calc for the Year_Month, or two calcs, one for the Year, and one for the Month. This way you can summarize multiple year's data without having them run together. The fields might look like this:

DateYear (calculation, number result) = Year(Date)

DateMonthName (calculaiton, text result) = MonthName(Date)

Using MonthName is probably preferable because it shows the month name rather than just the number, but using the MonthName will require you to use a value list containing the twelve month names in order for the sort to be sorted by sequencial month rather than alphabetically.

With the two separate fields, you'll need to have a separate sub-summary part for each.

Link to comment
Share on other sites

Thank you for the help. I don't think I have those functions available in my version of Filemaker? I have version 8. DateYear and DateMonthName don't come up as available functions in the functions window. MonthName ( date )does come up.

Thx again

Link to comment
Share on other sites

This topic is 5782 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.