Skip to Content

How to incorporate Median Formula in SAP Formatted Search or Query Generator

Hello there SAP community,

I'm quite having a problem on how to incorporate the Median formula in a Formatted Search or Query Generator; Can anyone please help me by sharing some simple codes so i can have an idea on how to ??? :-)

Thank you in advance

Kind regards

Noel,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 19, 2017 at 10:23 AM

    Hi Noel,

    A query can contain pretty much any formula. A very simple example:

    SELECT T0.ItemCode
          ,((T0.Price * T0.Quantity)-(T0.GrossBuyPr * T0.Quantity)) / (T0.Price * T0.Quantity) AS [Gross Profit]
    FROM INV1 T0
         INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry
    WHERE T1.DocNum = [%0]

    If you know the formula you just have to fill in the variables (fields)

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded