Conditional minimum (lowest positive value)

[former_member338618]

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

[abhilash_kumar · Accepted solution]

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