Skip to Content

Count the number of open PO

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 10, 2017 at 08:15 AM

    HI,

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

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 12, 2017 at 11:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded