I am no expert on crystal or programming so I hope this post isn't too simple-minded...looking to insert a section into my report that will change the master date range to a range 30 days previous and will run through all the formulas.

 

I've set up a parameter field called "Date Range", which allows the user to enter in a date range for the data to be run. So in select expert I have

{Match.Date} = {?Date Range}

 

I'm inserting a formula into the report to be based off a date range that is 30 days prior to what the user enters so I can calculate a percentage for that previous 30 days to compare with the percentage of the 30 day period the user entered.

 

So I am thinking something like

{Match.Date} = (minimum({?Date Range})-30) to (maximum({?Date Range})-30)

 

however how can I get this to run through all the formulas and logic to get a percentage for this altered date range.

 

the ultimate formula that calculates % for the user based on parameter field "Date Range" is

 

IF
isnull({@Locations})=true
THEN
0
ELSE
((distinctcount({@Locations},{@Origin})-{@late})/distinctcount({@Locations},{@Origin}))*100

I need to get this to also run for