Apply formula at Subtotal in Bex Report

[Amit_Rajput]

Dear Experts,

I have a requirement where I have to apply formula on subtotal values.

As shown in below example I would like to calculate the Open Qty after doing the subtotal at Item level.

Can you please suggest the way to achieve this requirement in Bex Report?

Doc Number	Item	Order Qty	Delivery Doc	Delivery Qty	Open Qty
100	10	10	801	2
100	10		802	4
	Subtotal	10		6	4

Thanks & Regards,

Amit Rajput

[cornelia_lezoch · Accepted solution]

define the formula

go to calculation properties

set the property for single values to "hide"

regards

Cornelia

[Amit_Rajput · Accepted solution]

Dear Cornelia,

Thanks for the suggestion. I will check this and will update you about my findings.

Regards,

Amit Rajput

[Amit_Rajput · Accepted solution]

Dear Cornelia,

It's perfectly working fine. Thanks for the suggestion.

Regards,

Amit Rajput