Skip to Content
0
Former Member
Nov 06, 2013 at 06:50 PM

BEx Query calculated key figure each navigational state (e.g. net value with and without schedule line)

50 Views

Hi experts,

I want to evaluate the net value of the confirmed quantity each schedule line with the simple calculation quantiy * net price.

The standard navigational state of my BEx Query looks like as follows:

Sales document / Sales doc. item / Schedule line -> and the calculated key figure net value (quantity * net price)

In the standard navigational state all things works fine and the net value is will be calculated correctly.

But, if I remove the schedule line characterstic from the navigational state, the calculated net value is incorrect because the net price is aggregated over all the four existing schedule lines (1, 2, 3, 4)

Any ideas? Should I use the constant selection for the key figure net price or any other aggregation settings each key figure?

Many Thanks in advance!

Regards,

Michael

Attachments

ScheduleLine.png (14.0 kB)
LineItem.png (5.7 kB)