SqlDbx Forum

SqlDbx

You are not logged in.

#1 2013-06-20 10:19:17

samspritzer
Member

Decimals

How come CONVERT(DECIMAL(10,2),Amount) AS [Sales Type 1] is still showing as ### instead of ###.##?

Offline

#2 2013-06-20 13:33:48

sqldbxhelp
Administrator

Re: Decimals

What type is amount? Does it has fractional portion?
If amount is integer and Results Options ->Truncate trailing zeroes is on than display format will be ###
otherwise it should be ###.##

Offline

#3 2013-08-05 08:27:19

samspritzer
Member

Re: Decimals

Sorry for the delay...the trim trailing zeroes was checked.  Unchecking it fixed the problem.  Thanks!

Offline

Board footer

Powered by FluxBB