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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Last 6 Months Sales Report MTD, LFM, ext.
I'm working on a sales report that gives monthly totals for the last 6 months. The issue is it works fine for the current month using MTD and LastFullMonth. I need a formula for the previous months and corresponding headers. if {SA_1_NF.Invoice_Date} in LastFullMonth then {SA_1_NF.Sales}. I'm...- wonderif1
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Replace Text
I have a question that relates to replacing a 2 character text field with a 2 character text input. I'm using CR 9. Here's my example:{SA_1_NF.Ord_Class} like ["BVF", "CA", "CP", "ER", "ES", "EU", "OM", "ST"] The text that I want to replace is the "OM" field with "RM". This order class will also...- wonderif1
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Fiscal Year Formula Summing
I,m very new to CR and I think I have a basic question. The report that I'm building will calc multiple fiscal years for parts sold from my inventory. I have been successful summing the parts level by fiscal year and now I'm summing them at two other grouping. Example if{@DateFY2001} then Sum...- wonderif1
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
