Trucate a number

[jjacob]

I need to show a number as a whole without rounding it.  Changing the decimal setting to "0" performs rounding.  I've attempted to use function TRUNC with no success.

Ideas/Suggestions?

[BigChris]

You could try casting it as an integer, or use the Int function.

[Lynn]

Or maybe the floor function.

[jjacob]

I did get this to work late yesterday by casting as an integer.  Thanks for the help!

[MFGF]

I did get this to work late yesterday by casting as an integer.  Thanks for the help!

I'd expect Lynn's floor() function suggestion would be a more efficient solution than using a cast() function?

Cheers!

MF.

[AnalyticsWithJay]

I'd expect Lynn's floor() function suggestion would be a more efficient solution than using a cast() function?

Cheers!

MF.

I agree with MF's statement. Be careful with using Cognos' cast() function because it's a locally processed function. It will not be as efficient as floor(), which is sent to the DB for processing.