4 Replies Latest reply: May 21, 2012 6:51 AM by Marco De RSS

    if condition in min value

      Hi all
      I have to calculate the min value of the size "sales".
      I know that the syntax is: min(sales)
      Before calculating the min I have to normalize the format of the sale's values. For do this I use this:
      if(sales<100, sales,
      if(sales>100 and sales<10000, sales/100,
      if(sales>10000, sales/1000)))
      Now how can I calculate the min of the value "sales" determined in the if condition?