Need Help Creating Over-Delivery % Report Based on PO in SAP Business ByDesign

[ankit-205]

I’m working on a custom report in SAP Business ByDesign to identify Purchase Orders (POs) where the delivered quantity exceeds the ordered quantity. I’d like to filter the report to show only those PO numbers with over-delivery and also calculate the percentage of over-delivery.

Here’s what I’ve done so far:

Data Source Used:

• Purchase Order Item Details

  Goal:

  1. Filter only those POs where Delivered Qty > Ordered Qty

  2. Show a % over-delivery calculated as:

      

     CopyEdit

     (Delivered Qty - Ordered Qty) / Ordered Qty * 100

     ---

     🧪 What I Tried:

     • Created a custom Key Figure for (Delivered - Ordered Qty) → Works fine.

     • Created another Key Figure for Division, then Multiplication by 100.

     • But I couldn't get the percentage to display in percentage format—values appear as decimal numbers instead.

     • Also, I couldn’t filter the report to only show POs with over-delivery using that formula.

       ---

       🆘Where I’m Stuck:

       1. How can I apply a filter so that I only see POs where delivered quantity is greater than ordered quantity?

       2. Is there a way to get the over-delivery % to show correctly in percentage format, not just as decimal values?

          ---

          ✅Any help would be appreciated!

          If this isn't fully achievable using a calculated key figure, maybe there’s an alternative approach (e.g., using a different data source or a workaround)?

          Thanks in advance