I have got a peculiar senario while executing a query.
The query result is not matching with the line items sum.
i have checked the definition of result, which is as nothing defined.
When I check for the same values in another query, and correlate this with the current one, there is always a difference in the result, where as the line items match in both the cases.
The second query is giving out a correct values.
However this query is giving out correct sum sometimes and mostly it is giving the wrong value in the result column.