Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculations at Query

Hi,

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.

Thanks.

Vinci.

Message was edited by:

Vinay Dutt

Former Member
Not what you were looking for? View more on this topic or Ask a question