1 Reply Latest reply on Nov 21, 2016 6:00 PM by Shinichiro Murakami

    Rounding to Field to Nearest .25 in decimal place

    Adam Ehrenworth

      I have fields that represents Hours with a whole number and decimal place.  i.e. 1.333

       

      I want to create a calculated field that rounds to the nearest quarter decimal place. So 1.333 would be become 1.25 and 4.56 would become 4.5 etc. What is easiest formula to use to accomplish this?


      Regards,


      Adam E