12-28-2007 6:31 AM
Hi all,
currently i need to do a total count value for my record for jus a particular field. and make it to a percentage for user to see. but how do i cater it in a way where my percentage other than showing a whole number out it can also show it decimal place? An etc of my scenario is listed below:
Male -> 102 count = 64.56%
Female -> 50 count = 33.44%
May i know what is the code for that? thx.
12-28-2007 6:34 AM
declare ur variable male and female type P decimal 2.
data: male type p decimal 2,
female type p decimal 2.
12-28-2007 6:34 AM
declare ur variable male and female type P decimal 2.
data: male type p decimal 2,
female type p decimal 2.
12-28-2007 7:32 AM
Hi jackandjay,
thx for your helpful solution. i managed to solved it with ur help.