5 Replies Latest reply: Jun 21, 2013 8:06 AM by Amit Gupta RSS

    Min and aggr function are returning second lowest value when min value is zero

      Hi,

       

      I am trying to get the minimum value using the expression shown below:

      Min(Aggr(Price,Item_Code))

       

      Minimum value obtained is correct when minimum value is non zero but if the minimum value is zero I am getting the lowest value greater than zero ie second lowest value.Is it possible to correct this?

       

      Regards,

      Amit