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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ghmd47

    YTD revenue formula

    Thanks! I will tried this formula.
  2. ghmd47

    YTD revenue formula

    I think it run from January 1 to December 31. But I need to check with our accounting. Do you know how to write this formula. I can't get 2010 YTD. I just saw year 2006 base on this formula. But i want to get 2010 YTD. I am sure my data have fiscal year 2010. Please help me!!! Tks,
  3. ghmd47

    YTD revenue formula

    YTD by posting_date. Posting_date is a date type field and fiscal_year is a number field. I created two formula for revenue: first is current_year: if month({GLTRANS.POSTING-DATE})>=12 then Year ({GLTRANS.POSTING-DATE}) + 1 Else Year ({GLTRANS.POSTING-DATE}) the second is YTD-Revenue...
  4. ghmd47

    YTD revenue formula

    my table have these data field Account, posting_date, fiscal_year and Tran_amount. I would like to create a calculation for revenue base on these field, but I can't get the YTD amount for Revenue. Here is my formula: if({GLTran.Account} >=40010 and {GLTran.Account}<=44610) then...
  5. ghmd47

    YTD revenue in crystals report

    Hello, my table have these data field Account, posting_date, fiscal_year and Tran_amount. I would like to create a calculation for revenue base on these field, but I can't get the YTD amount for Revenue. Here is my formula: if({GLTran.Account} >=40010 and {GLTran.Account}<=44610) then...

Part and Inventory Search

Back
Top