Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Calculation fields question? Post Reply Post New Topic
Author Message
mapperkids
Newbie
Newbie
Avatar

Joined: 04 Jun 2007
Location: Canada
Online Status: Offline
Posts: 1
Quote mapperkids Replybullet Topic: Calculation fields question?
    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!

 

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.