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
(BOB member since 2008-11-12)
Try this
%=[Total Population]/Sum(Total Population) In Report
KhoushikTTT
(BOB member since 2005-02-24)
It is throwing an Multi Value erro.Do you have any other Code?
Thanks
Pooja
ktm
(BOB member since 2008-11-12)
if you are placing in the cross-tab footer,
%=Sum([Total Population])/Sum(Total Population) In Report
KhoushikTTT
(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
(BOB member since 2008-11-12)
Could you paste the formula you are using.
KhoushikTTT
(BOB member since 2005-02-24)