AnsweredAssumed Answered

Calculation field - rounding up and leave out value

Question asked by hanstrager on Mar 23, 2014
Latest reply on Mar 24, 2014 by 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.

      

Outcomes