How to move from one report (with positive Qty) to another (Negative Qty) ?

[Former Member]

Hi all,

There is Quantity column in BEx query and I have a Calculated Key Figure on Quantity to have only POSITIVE values (> 0). Now the requirement is to have another report which are excluded from first (main) query because of NEGATIVE values (< 0). Basically, the first report will have only POSITIVE Quantities and we should drive from there to another report which will have NEGATIVE Quantities.

Could you please tell the steps to accomplish it with RRI, PLEASE ?

Thanks,

Venkat.

[Former Member]

Hello;

Why don't you create a calculated KF just for the quantity.

Then, on the first report you make a condition (quantity > 0). for that CKF.

In the second report you do the same but for negative.

See this link for more details:

http://help.sap.com/saphelp_nw04/Helpdata/EN/c1/5f6039ae48e623e10000000a11402f/content.htm

Regards;

Ricardo