Search results for query: *

I figured it out! Thanks! I changed my record selection to: {lwmain.date_rept}>={@STARTFORMULA} AND {lwmain.date_rept}<={?END DATE} And I created a formula(@STARTFORMULA): DATEADD("D",-DATEDIFF("D",{?START DATE},{?END DATE}),{?START DATE}) Then in my running total evaluate I used...

In the running total, I'm summarizing lwcharg.ucr_code as a count. In the evalute section I have tried these formulas. {lwmain.date_rept} >= dateadd("d", -datediff("d",{?START DATE}, {?END DATE}), {?START DATE}) and {lwmain.date_rept} <= {?END DATE}; {lwchrg.ucr_code}="220" AND {lwmain.zone}...

Thanks for your help but apparently I'm going to need someone to spell it out for me. I've spent days trying to get this to work and I think I'm about to throw in the towel! I've only been working with Crystal the last month so I'm easily confused:(

I'm sorry I'm new to Crystals. I don't know what you mean by two running totals. Is this all going to go into the running total field I created?

Maybe I'm not doing something right but it didn't seem to work. I used {lwmain.date_rept} >= dateadd("d", -datediff("d",{?START DATE}, {?END DATE}), {?START DATE}) and {lwmain.date_rept} <= {?END DATE}; {lwchrg.ucr_code}="23F" AND {lwmain.zone} IN ["Z1","Z2","Z3","Z4","Z5","Z6","Z7","Z8"] in...

I'm working on a formula to calculate the number of criminal offenses that occurred in the same amount of days as my date search parameter but prior to the start date. The date search parameter is always changing. The idea is to compare the number of offenses from the last time period. For...