2 Replies Latest reply on Mar 24, 2014 3:35 PM by hanstrager

    Calculation field - rounding up and leave out value

    hanstrager

      Title

      Calculation field - rounding up and leave out value

      Post

           I have a 2 questions, which I think could be quite basic.

           1st question: I have a calculation field that is calculating a price, for a product based on different materials. I want to have this to always round up to the the nearest 5's... so 1-4 would = 5 and 6-9 would = 10

           Tried to look into the round() function, but couldn't get it to work.

           2nd. question: Is it possible to have the calculation field not show a value if one of the fields it’s calculations have no input.