Need help with running total formula

[MrHelpMe]

Hello have a report that I need to show MTD Net sales, YTD Net sales and Net Switches Transfers. Now I have successfully created MTD Net sales and YTD Net sales however, when I get to the net switches I need the report to just show net switches for the current month or more specifically my operating system month. I have created this formula called net switches which shows the difference. This is not my problem, my problem is when I try and do a running total on this formula(net switches) that is working correctly, how do I get it to say just do a running total on the month that I am looking for(my OS clock month)
I have created a reset, running total and display running total formula. But it adds everything not just data for the month. Your help is appreciated. Thanks.

 

[lbass]

In your details level running total set it up something like:

whileprintingrecords;
numbervar netsw;

if {table.date} >= Date(year(currentdate), month(currentdate), 01) then netsw := netsw + {@netsw} else
netsw := netsw;

-LB

 

[Madawc]

If you have Crystal 8.5, you could also use lbass's formula as the add-control formula in a runing total.

Madawc Williams
East Anglia, Great Britain