Comparing Data from Different Dates

[twilliamson2]

I am using CR X and an Oracle database.

I would like to compare data from two or more dates.

For example:
As of 10/31 As of 11/5
# % # %
Date of Birth Errors 26 15% 6 .5%
Date of Hire Errors 27 16% 5 .4%

At this time, I have 2 separate reports. How can I create a report that shows the data in one report? In addition, how can I create a % change in the report?

 

[lbass]

Can't tell from your post what the percents relate to. Please show a sample where the totals are included so we can see what the percent relates to. Are you then looking for an additional percent?

Also, your use of "as of" seems to imply that you are showing cumulative amounts, although your data suggests otherwise.

Finally, in your sample, what are the current formulas for the summaries? What field(s) are used for the date of hire and date of birth errors? We just need more info.

-LB