Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Conditional minimum (lowest positive value)

Hi,

I have a series of values ranging from -50 through to 999, I want to be able to show the lowest positive value to allow record suppression.

e.g.

The data being reported is from our purchase price book

I would like to be able to suppress all but the highlighted row on the following example (so I would need a formula that will return 1.02), however, the lowest positive qty will vary from part to part and the lowest positive is not always going to be the 3rd record.

Thanks in advance for the help

Andrew

replied

Hi Andrew,

1) Create a formula called (@Min)with this code:

if {Qty} <= 0 then 9999

else {Qty}

2) Go to the Section Expert > Details Section > Click the formula button beside Suppress and use this code:

{Qty} > Minimum({@Min})

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question