Round Down

[mellicks]

Hello. I have a formula and I have the result as a whole number. I always need the result to round down, not up to the next whole number. How do I do that? I can only get it to round up to the next whole number.

For example, if my result is 120.67 then I want it to say 120, not 121.

Thanks,
mellicks

 

[mellicks]

Sorry, forgot to mention I'm using crystal XI version.

 

[dunlop1975]

Just use the int() function

so int(120.67) or int(<equation>)

 

[CoSpringsGuy]

use floor

floor(4.9,1) = 4
floor(4.1,1) = 4

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[CoSpringsGuy]

int will work fine but if you choose to use that method you might want to consider substituting truncate for int if you ever expect to have negative numbers.

int(120.67) = 120
int(-120.67) = -121
truncate(-120.67) = -120

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[mellicks]

Thanks so much!