4 Replies Latest reply on Jan 6, 2017 4:56 AM by Jim Dehner

    Round up number to nearest thousand

    Stephen Lavery

      I am trying to round up numbers to the nearest thousand. I found this post and answer by kettan: How to round up numbers by nearest million? Which was very helpful but when I adapt the calculation to look like this:

       

      IF INT([Number]/1000)*1000 = [Number] THEN [Number] 

      ELSEIF SIGN([Number]) = -1 THEN INT([Number]/1000)*1000 

      ELSE INT([Number]/1000)*1000+1000 

      END

       

      It doesn't round up as I want it to... Here's how I would like the calculation to work:

       

       

      Any suggestions much appreciated.

       

      Stephen