Calculations at Query
We are facing the following problem getting out the correct values for formulae at query time.
I am giving the example records for an easy understanding.
Sales Doc Item qty value
1 10 1 2
1 20 3 6
I have to calculate the net price which is a formula derived by multiplying the qty and value fields.
Suppose my query does not iunclude the Item field in the rows, the output will be
32 which will give me the wrong value. I cannot include the sales doc number in the report. Even I cant include it and hide it because it will spoil my report layout.
This must be a problem which everyone might have faced. Please share your views on this.
Message was edited by: