Search results for query: *

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...

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...

I have a question that relates to replacing a 2 character text field with another 2 character text input in a formula. 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". Help...

lbass, It worked, Thanks so much. Maybe someday this will all make sense to me.

The Report that I'm trying to generate looks like this. Customer Name Total Sales FYYTD FY2003 FY2002 FY2001 $$$$ $$$ $$$ $$$ $$$ Ddown to Order Class by Fiscal Year (same Columns) Ddown to the Parts #Sales Fiscal Year (same Columns) The Grouping looks...

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...