Total function not working for a particlar value in list report

[sreevathi]

I have a list report which has residual values for a particluar prompt.When a total is done on the residual values for a selected application name ,it gives me a large amount whereas the values should be much lesser .
For eg,
    Application name A
    Residual values  on a particular date are - 1000,7636,8932
When i use the total agg.function, it gives a very large value which in case shud give me the sum of all these 3 values.
But, max,min and avg function works fine and gives me the exact value.

Any thoughts on this issue.

Thanks

[Gollapudi]

You Should try using "FOR" class along with Total function...

Gollapudi.

[sreevathi]

I did try the 'FOR' class along with total function but it didnt work.It still gives very large values .

[Gollapudi]

Can you please tell me how did you incorporate that statement.