Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mrtanner

  1. mrtanner

    Prior Year Formula

    beltmanjr, Thanks for your answer. Yes I think that may be the best solution, simplify and work from there. I will check out the link you provided with interest. Thanks again Mr Tanner
  2. mrtanner

    Prior Year Formula

    Tatertot45, Unfortunately I don't need a YTD figure but a figure of the debtors as at the same time in the previous year. Thanks for offering your help and I will keep those formulas in mind for future reference Mr Tanner
  3. mrtanner

    Prior Year Formula

    Has anyone got any ideas for me???? Mr Tanner
  4. mrtanner

    Prior Year Formula

    Hi Guys, Got another problem with prior year formulas. I am using an Oracle 9 database with Crystal Reports XI. This is the formula I am trying to edit but with no success:- select d.descr as department, n.refno as bill, m.fileid, c.name, c.nclient...
  5. mrtanner

    Prior Fiscal YTD Figures

    Lb, Works perfectly.. Thanks again for all your help. Mr Tanner
  6. mrtanner

    Prior Fiscal YTD Figures

    Formula as follows:- if {NMEMO.DISPATCHED}= LastYearMTD then {NMEMO.FEES} else 0 Mr Tanner
  7. mrtanner

    Prior Fiscal YTD Figures

    Sorry, I can do the MTD and MTD last year from the builtin formulas, but how would I do MTD 2 years ago?? Mr Tanner
  8. mrtanner

    Prior Fiscal YTD Figures

    Lb, One last question...Would I use the same basic formulas to do MTD, and MTD last year?? Mr Tanner
  9. mrtanner

    Prior Fiscal YTD Figures

    Mate, It seems to be working now...Don't know why but I'm not complaining..Thanks for all your time and help with this problem.It really is appreciated.. Mr Tanner
  10. mrtanner

    Prior Fiscal YTD Figures

    Sorry, I misunderstood. Did what you asked and this was the result: 21/05/2003 12:00:00AM Mr Tanner
  11. mrtanner

    Prior Fiscal YTD Figures

    Ok, I got a result. I used the record selection ( I guess thats what you meant) of greater than or equal to 01/07/2005 since that is the earliest data we have. The total doesn't equal the total shown in our reports but at least we have data. Was the record selection what you wanted me to do...
  12. mrtanner

    Prior Fiscal YTD Figures

    lbass, I don't have a record selection. Here is the info from Ken's tips which as far as I can see says that there is no record selection for this and there isn't in his example and should just give info for the previous year to current date: 69. Calculating fiscal YTD (Report 67) The Crystal...
  13. mrtanner

    Prior Fiscal YTD Figures

    lbass, Yes I am putting the formulas in details and then summing them in the report footer. The only thing I can see that's different from Ken Hamadys formula is that when I browse the data for @fiscal year, all years show where as in mine the only year I get is 2008? This is his formula...
  14. mrtanner

    Prior Fiscal YTD Figures

    Thanks lbass. Forgot to put these in. Here they are- Fiscal Year: Year ({NMEMO.DISPATCHED}+184) Current Fiscal Year: Year (Currentdate + 184) Our Fiscal Year is from 1st July to 30 June. Thanks again Mr Tanner
  15. mrtanner

    Prior Fiscal YTD Figures

    Hi Guys, I have checked out all the threads to do with this and nothing seems to work. I have downloaded Ken Hamadys formulas and have been using them but can't get this to work. I have created formulas for fiscal year and current fiscal year. The formula for YTD works beautifully but when I...
See more

Part and Inventory Search

Back
Top