Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Percentage values in a Cross Tab Crystal using decimal points

Status
Not open for further replies.

kezdawg

Programmer
Apr 2, 2008
19
GB
I have seen some posting on this topic already but i just cant get it to work for my scenario.

I have a cross tab that i want to display with decimal points for the percentage values. When i do it crystal is truncating the decimal points to zero decimal points and hence the percentage values do not add up to 100%



Cross Tab as follows using count

Age 18 Age 19 Total
Female / Place A 13 14 27
Female / Place B 2 6 8
Male / Place A 6 7 13

I then want to portray these are precentage values going into multiple decimal points

Age 18 Age 19 Total
Female / Place A 48.14 51.85 100
Female / Place B 25.00 75.00 100
Male / Place A 46.15 53.85 100


 
Please try the method in thread149-1370605.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top