how to calculate percentage

[former_member196948]

Hi All,

I need to Calculate percentage distribution by dividing the number of "CAR_SOLD"  for  each "STATE_CODE" by the total number of vehicles in the US for the State "STATE_CODE"

I am using sap BO 3.1

state code	year	car sold
CA	2000	52
CA	2001	31
CA	2002	31
CA	2003	40
CA	2004	25
CA	2005	25
CA	2006	28
CA	2007	30
MI	2001	3
MI	2002	21

please advice

Ranjeet

[former_member196948]

Hi All,

How to resolve this issue

below is the sample data

state code	year	car sold
CA	2000	52
CA	2001	31
CA	2002	31
CA	2003	40
CA	2004	25
CA	2005	25
CA	2006	28
CA	2007	30
MI	2001	3
MI	2002	21

Thanks in Advance

Ranjeet

[arijit_das]

v_% Sold =[Car Sold]/(Sum([Car Sold]) In ([State Code]))

state code	year	car sold	% Sold
CA	2000	52	19.85%
CA	2001	31	11.83%
CA	2002	31	11.83%
CA	2003	40	15.27%
CA	2004	25	9.54%
CA	2005	25	9.54%
CA	2006	28	10.69%
CA	2007	30	11.45%
MI	2001	3	12.50%
MI	2002	21	87.50%