I have a report that I am working that generates a total number of cases that are specific to different areas of operation. For instance:
Total over 10 under 10 percent ?
accounting 20 2 18
marketing 34 4 30
The cases relate to technical issues. Each issues is assigned a case describing it and when the issue is resolved the case is closed. For accounting their were 20 tech issues, 2 took over 10 (to close) and 18 were under 10 days.
The percent column is what I don't have, but I need. I want the percent of days over 10, or 2/20, but I don't know how to get this in one extra column. Everything I do creates 2 more columns. I tried to right click on the report in the preview view, and select format cross-tab and add a column with the formula, but it adds 2 more columns. Do I need to add that 4th column(percent) in with my other formulas or can they all be separate and just added as a column in the format cross tab section?
I am new to crystal reports so I would appreciate it if your answers could be as specific as possible.