title: How do I chart a calculated percentage value in Crystal 9
body: <p>I am using Crystal 9 and have created a report showing calls logged by users, time taken to close the call, Solved with (allocated a value to the latter field depending on time taken eg. 1-59  mins = &lt; 1 hr = 1), 60-239 mins = &lt; 4 = 4.  I have then grouped the results by users and got totals for each of the Solved values</p>
  
  <p>Solved1 = solved in less than 1 hour</p>
  
  <p>eg group total shows (when record data hidden)    </p>
  
  <p>User1 (Total Calls= 74) (Solved1 = 42) (Percentage1 = 56.76) </p>
  
  <p>User2 (Total Calls= 17) (Solved1 = 2)  (Percentage1 = 11.76)</p>
  
  <p>Total Calls and Solved1 are obtained using Running Total Fields.
  Percentages are Formula fields and calculated as follows:
      Percentage1 = Solved1/Total Calls * 100</p>
  
  <p>My problem is that I need to graph the percentage values for each user for each Solved value eg.  56.76 and 11.76 on one chart. This would be easy except that Crystal doesn't let me select this field in the chart option because it's calculated from two Running Totals.  </p>
  
  <p>Since some formulas are accepted by the Chart expert and running totals are also accepted, is there a way I can calculate the percentage which it would find acceptable? Or can I put the total and Solved value in the chart and have the chart calculate the percentage somehow?  I was looking at using count and I can get the count to count all the records for a single person but not where say the value in a specific field = '1'
  eg  count (call_id, )/count (call_id, closedby) * 100  </p>
  
  <p>Does anyone know how I can write that fomula or any other way of graphing a percentage?          </p>