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

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.


atricureAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
WHere is the total?  How did you place it?

mlmcc
atricureAuthor Commented:
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.
atricureAuthor Commented:
Pie Chart Grand Total is calculating country J as a POSITIVE not a NEGATIVE
mlmccCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dylanyeeCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.