Alpha Video Training
Results 1 to 6 of 6

Thread: What is the formula to create a monthly and yearly report?

  1. #1
    Member
    Real Name
    Pat Domanski
    Join Date
    Jun 2009
    Posts
    79

    Default What is the formula to create a monthly and yearly report?

    Greetings,

    I am new to the Alpha Five 9 Platinum series and I am hoping to find an answer to my problem. What is the formula to create a monthly and yearly report? I would like to be able to tally up the sales for each month and the grand total for the year. This is what I am stuck on. I thank you for your help as I look forward to your response.

    Regards,

    Pat

  2. #2
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: What is the formula to create a monthly and yearly report?

    Hi Pat,

    Welcome to Alpha,

    When is a year? And when is a month? By name or a number of days? I know this sounds like daft questions but you have know where the start and end points are to use in the filter for your report.

    Are you inputting start and end dates when you run the report or is the report getting the values by some other means. Maybe you just want to run the report by selecting just the year. Would that be the current year or a year the user selects?

    Sorry to throw this back at you but as you can see from my few questions your question cannot be answered with a formula with out more info.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  3. #3
    Volunteer Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,644

    Default Re: What is the formula to create a monthly and yearly report?

    Quote Originally Posted by Patd View Post
    What is the formula to create a monthly and yearly report? I would like to be able to tally up the sales for each month and the grand total for the year.
    It's not so much the formula (although that too). Put a group break in your report. Select "expression" and put in month(your_date_field_here). Check the box for a group footer. Drag a new calculated expression from the task bar DragnDrop List and create a group total (that will be your monthly total). If your report will be for more than one year, duplicate the above for grouping by year (expression = year(your_date_field_here) and then a similar calc total for that group. If you report will only be for one year a t a time you will just need a grand total calc. In the latter case, you will need to filter upon the year before running the report.

  4. #4
    Member
    Real Name
    Pat Domanski
    Join Date
    Jun 2009
    Posts
    79

    Default Re: What is the formula to create a monthly and yearly report?

    Quote Originally Posted by Keith Hubert View Post
    Hi Pat,

    Welcome to Alpha,

    When is a year? And when is a month? By name or a number of days? I know this sounds like daft questions but you have know where the start and end points are to use in the filter for your report.

    Are you inputting start and end dates when you run the report or is the report getting the values by some other means. Maybe you just want to run the report by selecting just the year. Would that be the current year or a year the user selects?

    Sorry to throw this back at you but as you can see from my few questions your question cannot be answered with a formula with out more info.
    Hi Keith,

    I thank you for your response. The year is 2009 and the month is by name. I am inputting start and end dates and it would be the current year. Again, thank you.

    Regards,

    Pat

  5. #5
    Member
    Real Name
    Pat Domanski
    Join Date
    Jun 2009
    Posts
    79

    Default Re: What is the formula to create a monthly and yearly report?

    Quote Originally Posted by Peter.Greulich View Post
    It's not so much the formula (although that too). Put a group break in your report. Select "expression" and put in month(your_date_field_here). Check the box for a group footer. Drag a new calculated expression from the task bar DragnDrop List and create a group total (that will be your monthly total). If your report will be for more than one year, duplicate the above for grouping by year (expression = year(your_date_field_here) and then a similar calc total for that group. If you report will only be for one year a t a time you will just need a grand total calc. In the latter case, you will need to filter upon the year before running the report.

    Greetings Peter,

    Thank you so much for your help. I was trying to find the formula in the Alpha Five Made Easy book and the Functions Handbook. Maybe I missed it in the functions book? Again, thank you.

    I hope you don't mind me asking this other question on a different project?

    I am trying to keep track of dog license tag numbers for the current year, but when next year comes around, I want to be able to carry over those dog license tag numbers to next year while I would be able to have a seperate field to insert the new dog license tag numbers. If this is possible, what would I need to do? Thank you again Peter and enjoy your week.

    Regards,

    Pat

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: What is the formula to create a monthly and yearly report?

    I am trying to keep track of dog license tag numbers for the current year, but when next year comes around, I want to be able to carry over those dog license tag numbers to next year while I would be able to have a seperate field to insert the new dog license tag numbers. If this is possible, what would I need to do?
    You need to change the structure of your database.

    Think of an invoicing program that had only one field for product sold. You don't add more fields to handle more items. You have parent table that stores the invoice "header" information linked to a child table that stores individual detail lines. This allows for multiple items per invoiee and multiple invoices per customer.

    In your situation you need much the same sort of setup but your child table would record the tag nmber and the date issued as well.
    Last edited by Stan Mathews; 06-22-2009 at 10:06 AM.
    There can be only one.

Similar Threads

  1. report monthly columns
    By MikeC in forum Alpha Five Version 5
    Replies: 14
    Last Post: 05-26-2007, 09:41 PM
  2. Monthly Report
    By Ben Maldonado in forum Alpha Five Version 4
    Replies: 1
    Last Post: 10-18-2005, 01:25 PM
  3. Report Yearly Total
    By Ed Barley in forum Alpha Five Version 5
    Replies: 3
    Last Post: 03-24-2004, 06:53 AM
  4. Help Req Date for Monthly report
    By David Little in forum Alpha Five Version 5
    Replies: 18
    Last Post: 02-09-2004, 11:30 PM
  5. Can't print bi-monthly payroll report
    By LB Brantner in forum Alpha Four Version 6 and Prior
    Replies: 1
    Last Post: 06-20-2000, 04:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •