how to show correct total for percentage column in list report

[nsaxena]

Hi All ,

I have a list report in which column are like this

city     country   fact1       fact2
delhi    india       10           10%
paris    france     20           15%

fact one is numeric(numbers) and fact2 is showing a percentage value...

Now i want to show total of all the fact columns...when i am doing by selecting total i am getting fact2(percentage column as sum up too)
city     country   fact1       fact2(percentage)
delhi    india       10           10%
paris    france     20           15%
Total                   30           25%

Please suggest a way to avoid this so that it will show real total percentage instead if sum

[krishdw85]

percentages do average

[nsaxena]

hi..i do not need average...

my calculation for fact(percentage field is ) : data item 1/total

[Nagendar]

Hi Nsaxena,

Try to use "Rollup Aggregate Function" (ex: Calculated) Property and "Data Format"  (ex: Percent).

Thanks
Nagendar