Showing YTD for previous years

[redbunny78]

Using Crystal X and Oracle

I have a report that shows YTD numbers based on a DateTime field. I also need to show the YTD numbers for last year and for this month last year.

The output would look like:

2007 YTD /Success Rate 1160595/96%
2006 Oct /Success Rate 1440179/95%
2006 /Success Rate 1717963/95%

What formula would I use show those numbers for last year?

Thanks!

 

[lbass]

Try something like:

//{@YTD} through last full month which it appears you are looking for:
if {table.date} in date(year(currentdate)-1,1,1) to
dateserial(year(currentdate)-1,month(currentdate), 1)-1 then
{table.qty}

//{@lastfullmolastyear:
if {table.date} in dateserial(year(currentdate)-1,month(currentdate)-1,1) to
dateserial(year(currentdate)-1,month(currentdate), 1)-1 then
{table.qty}

Place these in the detail section and then use summaries of these for your calculations.

-LB