Solved

# Pie Chart (negative values) calculating as positive in the LEGEND

Posted on 2006-03-20
1,616 Views
Product: Crystal Reports XI Enterprise

I have a pie chart that is displaying values of the slices in the legend. The total that is represented is adding a negative as a positive even though the legend is displaying the figure as a negative. Here is what is being displayed:

Country A       \$115,745
Country B       \$8,400
Country C       \$100,800
Country D       \$9,050
Country E       \$0
Country F       \$44,475
Country G       \$45,000
Country H       \$22,050
Country I        \$28,440
Country J        (\$24,140)
Country K       \$12,240

Total             \$410,340

The correct Total should be \$362,060 which displays correctly in the Report Footer Grand Total. Country J is a negative and the report details represent this, it is only in the legend that the sum figure incorrectly.

Any help would be greatly appreciated.

0
Question by:atricure

LVL 100

Expert Comment

WHere is the total?  How did you place it?

mlmcc
0

Author Comment

The correct total, Grand total is in the Report Footer. Group totals are in the group footers. All totals are displaying correctly in the rport itself just not in the LEGEND of the Pie Chart.
0

Author Comment

Pie Chart Grand Total is calculating country J as a POSITIVE not a NEGATIVE
0

LVL 100

Accepted Solution

I don't know unless because a pie chart is used to show how much it can't handle or handles negative values incorrectly.

mlmcc
0

LVL 8

Assisted Solution

atricure, The concept of Pie Chart is to handle only positive value, which will display the percentage of each item participate in the circle. Imagine that you have a negative value, how are you going to display it using pie chart?
If you have negative value in your chart, pie chart is certainly not suitable in your case, use bar char instead.

dylan
0

## Featured Post

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…