6 Replies Latest reply: Jun 1, 2011 3:18 AM by Christian Conejero RSS

    How to find lowest value except 0.

    Abhijit Bansode

      Hi,

      I want to find outh the minimum value of the sum(Amount) excluding 0.

       

      below is the example, Shows listbox with expression and Frequency of occurance of each value.

       

      Product

      Sum(total<Product>Amount)

      Frequency

      J1

      4692236651

      56765

      C1

      17058822429

      787

      D1

      3451481830

      6875676

      O1

      1947505462

      56

      S1

      5303848371

      576

      M1

      384027272

      756

      G1

      1338660

      576

      Y1

      1245244

      576

      T1

      900437982

      45

      Y1

      0

      2

      Z1

      12

      123

       

      Here lowest value is 12 excluding 0. so i can find out thhis using

      Min(Sum(total<Product>Amount),3). here i've use second parameter as 3 because 1st two values are 0. but this is not the case all the time. each time i may not know how many entries of 0 will be there,  how should i find out this minimum value.