CEILING and FLOOR functions

[20 Ton Squirrel]

TM1 lacks the CEILING and FLOOR functions but I recently set about emulating them formulaically. I hope posting this here helps someone in the Distant Dark Future™

Code: Select all

[ 'Ceiling' ] = N: 
    ( INT ( [ 'Value' ] \ [ 'Significance' ] ) 
     - IF ( [ 'Value' ] \ [ 'Significance' ] - INT ( [ 'Value' ] \ [ 'Significance' ] ) > 0 
           , -1
           , 0
          ) 
    ) * [ 'Significance' ] ;
    
[ 'Floor' ] = N:  
    INT ( [ 'Value' ] \ [ 'Significance' ] ) * [ 'Significance' ] ;

[jim wood]

You should put this in the useful code section of the site. It's very useful and in the main forum it will get moved down quickly. Let me know if you'd like it moved over there?

Jim.

[20 Ton Squirrel]

Sure! Scoot it on over there. Thanks, Jim!