Difference

[lisa626]

Crystal XI

Have a report as follows:

Grp 1, DatabaseName
Grp 2, Table Name ACount ACost

Details are suppressed, what I need to be able to do is the following:

CASTLE
TICKET 25 3200.00
CAR 16 3185.00
HOTEL 13 3030.00
AIRSEG 85 8200.00
STL3
TICKET 22 3110.00
CAR 13 3095.00
HOTEL 09 2859.00
AIRSEG 79 7800.00

I need to be able to show the % difference from the Ticket count in Castle to the Ticket count on STL3, results should be as follows.

CASTLE
TICKET 25 3200.00
CAR 16 3185.00
HOTEL 13 3030.00
AIRSEG 85 8200.00
STL3
TICKET 22 12% 3110.00 03%
CAR 13 19% 3095.00 03%
HOTEL 09 31% 2859.00 06%
AIRSEG 79 07% 7800.00 05%

In essence this is showing that 12% of the tickets that are in Castle are NOT in STL3, any help would be appreciated.

TIA

 

[dgillz]

Please xplain how you are coming up with 12%.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lisa626]

OOPS, SORRY

25-22 = 3/25 = 12%

 

[Madawc]

You can do a running totals for the whole report that just accumulate for Castle, and another for STL3. That means you can compare them.

You can also find what percentage each group is, as part of the total.

If you're not already familiar with Crystal totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10