Print Page | Close Window

Calculation fields question?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=780
Printed Date: 04 May 2025 at 11:08pm


Topic: Calculation fields question?
Posted By: mapperkids
Subject: Calculation fields question?
Date Posted: 04 Jun 2007 at 9:17am

Hi,

I'm using the CR v 11 and I did a 3D bar chart that showing two series of data for each salesman , one is their outstanding orders and the other one is the closed orders.

Both bars are get the value from two running totals that I defined in the report  by a distrinct count on salesman name.


For example for salesman_A , the bars are showing like

15 outstanding orders
70 closed orders

Now I want to show the percentage for the outstanding and closed orders. How can I do it?


Based on the example above.

The calculation is  15  / (15 +70) * 100  = 17.64%

Any suggetion? ideally can put that percentage on the report somewhere or as another data series on x aixes.

Thank you!

 




Print Page | Close Window