How to create a Chart on the total of RT formulas

[BradCustom]

Hi all,

I'm using Crystal Reports 2008 and I'm trying to create a pie chart to show the precentage of the total for each running total.

Below is each running total fomula which are placed in GF1

CountRed: (is a running total formula that counts the number of records that meets the following criteria on {@SchDayRem}

{@SchDayRem} < 0 or
(
datediff ("d",{@CurrentDate},{Job_Operation.Sched_Start}) < 0 and
{Job_Operation.Status} in ["S","O"]
)

CountYellow: (is a running total formula that counts the number of records that meets the following criteria on {@SchDayRem}

{@SchDayRem}=0

CountWhite: is a running total formula that counts the number of records that meets the following criteria on {@SchDayRem}

{@SchDayRem}>0

For reference the formula {@SchDayRem} is listed below:

datediff ("d",{@CurrentDate},{Job_Operation.Sched_End})

I've also created a forula which totals the CountRed, CountYellow and CountWhite which is called {@TotalCount}.


What I'm trying to do is to show in a Pie Chart the percentage of each count to the total count.
An example of the totals would be:
TotalCount = 181
TotalRed = 103 %56.9
TotalYellow = 0 %0
TotalWhite = 78 %43.1

What I've tryed so far Crystal Reports says is not a vaild Chart and it gives me three seperate charts.

Any help would be great!
Thanks!

 

[BradCustom]

NO NEED TO RESPOND TO THIS POST ISSUE HAS BEEN RESOLVED

 

[lbass]

Please explain how you resolved the issue so the thread is useful to others.

-LB