Column Chart percentages does not equal 100%

[ramblinrose]

We have column charts that are displaying percentage of value. The problem we are having is that not all of the charts do not total 100%. We are rounding the numbers and our customer only wants to see whole numbers. We are using Crystal Report 2016 and have CRChart. The are hundreds of carts based on our county's budget and are printed in a book.

Is there a solution to displaying percentages that will ultimately total 100%

Thank you,
Rose Mary

 

[Smith_J]

Check if this works.

It can be done in a crosstab by changing the summary to be a percentage

It can also be done with formulas
Is it a single field or a summary?

Formula
{YourField} / Sum{YourField} * 100

Display with the %

--
Smith
Apps4Rent