How can I create charts off formula fields? 1

[deborahyr]

I am working with Crystal XI. I have formula fields set up to give me the percentage of a field on my report.

Total Positions = 10
Total Positions w/Talent = 6
Total Positons w/Talent in 2 yrs = 10
Total Positions w/ER only = 0

I created formula fields to get percentages.

<TPs> / <TPs> * 100 = 100
<TPwTalent> / <TPs> * 100 = 60
<TPwTalent2yrs> / <TPs> *100 = 100
<TPwERonly> / <TPs> = 0

I want to grab the results of these formulas and put them in a chart but they did not appear in my chart data list to select. They are clearly in my formula fields list and are on the report. What am I missing? Or is there another way to get

 

[Madawc]

DO they include summary values?

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

 

[deborahyr]

Yes, the <TPs> field is a summary field.
The others are running total fields.

 

[Madawc]

Groups work on detail-line data rather than values derived from serveral different records. I think the same applies for charts.

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

 

[lbass]

You could try writing a command that returns the summaries directly as fields. Then they would be available for charting. Otherwise you could check the BO site for "Charting on Print-time Formulas", which might apply in this situation.

-LB