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
You Should try using "FOR" class along with Total function...
Gollapudi.
I did try the 'FOR' class along with total function but it didnt work.It still gives very large values .
Can you please tell me how did you incorporate that statement.