how to make variable %?

I have a cross Tab reports .In that i have total pupulation column and need to make another column % of the Population
Total Population % of Population
100
200
300
200
1000(total)

I want to make a variable which shows the percentage of total population.

Thanks
Pooja:)


ktm :us: (BOB member since 2008-11-12)

Try this

%=[Total Population]/Sum(Total Population) In Report

KhoushikTTT :us: (BOB member since 2005-02-24)

It is throwing an Multi Value erro.Do you have any other Code?
Thanks
Pooja


ktm :us: (BOB member since 2008-11-12)

if you are placing in the cross-tab footer,
%=Sum([Total Population])/Sum(Total Population) In Report


KhoushikTTT :us: (BOB member since 2005-02-24)

I have to make one Column next to total population column and have % of total Population.
It is not working, In the column it has Population and at the end of the cell it is Sum(Population).
Thanks
Pooja


ktm :us: (BOB member since 2008-11-12)

Could you paste the formula you are using.


KhoushikTTT :us: (BOB member since 2005-02-24)