Skip to Content
0

Count the number of open PO

Jul 08, 2017 at 12:32 PM

76

avatar image

Hi,

I my BEX query i have the "PO Qty" keyfigure and "GR Qty" keyfigure.

Now i need to show the value of Total open PO's( that is "GR Qty" Not equal to "PO QTY").

I have created a calculated keyfigure for the above, say KF1 ( GR Qty <>

PO QTY ) * 1 + 0.

This works fine when i add the "PO Number" and "PO Item" to the report.

Now my user wants to see the count of open PO's month wise, so when i remove the PO number and Item from the drill down and add the "Calmonth", the "Caclulated keyfigure" does not help in this regards.

As it applies the formula for all the aggregated "GR Qty" & "PO QTY".

Is there any way we can take the Count of open PO's when there is no "PO number and item" in the output?

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Anand Kumar Jul 10, 2017 at 08:15 AM
0

HI,

Create formula variable on Calmonth then use the formula variable in calculated key figure with condition.

Regards,

Anand

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Jul 12, 2017 at 11:55 AM
0

Add it in your dataflow, so your knowledge of open items is stated for everybody and every report and easy reusable. The design of your query will be faster and more transparent.

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded