Alpha DevCon 2018
Results 1 to 3 of 3

Thread: Make yearly Report A Fiscal Year Report

  1. #1
    Member
    Real Name
    William Clementz
    Join Date
    Jun 2006
    Location
    Florida
    Posts
    36

    Default Make yearly Report A Fiscal Year Report

    I have a report of sales that are grouped for Year - str(year(Txndate)) , Quarter - int((month(Txndate)-1)/3) , and Month - month(Txndate). I would like to make a new report that would reflect our fiscal year - Oct. 1 to Sept. 30. I'm stumped to write an expression for this task. Or if it is possible. My set covers several years worth of sales data.

    Thank you
    Bill

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,479

    Default Re: Make yearly Report A Fiscal Year Report

    You'll need to make the year expression conditional based on whether the transdate is before or after Oct 1.

    If before then year(), if after, then year()+1

    or something like that...
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member
    Real Name
    William Clementz
    Join Date
    Jun 2006
    Location
    Florida
    Posts
    36

    Default Re: Make yearly Report A Fiscal Year Report

    Hmmmmmmmmmmmmm............. I think I see. Will work on that.

    Thanks

Similar Threads

  1. How do you show a date range on a quarterly and yearly report?
    By Patd in forum Alpha Five Version 10 - Desktop Applications
    Replies: 5
    Last Post: 04-13-2010, 02:01 PM
  2. How do you create a quarterly and yearly report using dates?
    By Patd in forum Alpha Five Version 10 - Desktop Applications
    Replies: 12
    Last Post: 04-12-2010, 09:54 AM
  3. What is the formula to create a monthly and yearly report?
    By Patd in forum Alpha Five Version 9 - Desktop Applications
    Replies: 5
    Last Post: 06-22-2009, 09:00 AM
  4. Report Yearly Total
    By Ed Barley in forum Alpha Five Version 5
    Replies: 3
    Last Post: 03-24-2004, 05:53 AM
  5. Fiscal Year
    By davej in forum Alpha Five Version 5
    Replies: 10
    Last Post: 05-28-2003, 07:35 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
  •