7 Replies Latest reply on Nov 18, 2013 8:40 AM by ultranix

    Conditional rounding

    ultranix

      Title

      Conditional rounding

      Post

           Hey,

           I have conditional rounding question, that i cannot solve by myself.

           Base calculation field formula looks like this:

           Case (price_now  ≥  150; //ROUND TO 5, i.e. 155, 160, 165//;
           Case (price_now  ≥  50; //ROUND TO 2,5, i.e. 52.5, 55, 57,5//;
           Case (price_now > 10; //ROUND TO 1 i.e. 11, 12, 13//;
           Case (price_now > 0; //ROUND TO 0,5, i.e. 1, 1,5, 2, 2,5//;))))

           How could i round to the mentioned measurements?