Thursday, 22 August 2013

Show only 2 numbers after percentage

Show only 2 numbers after percentage

I have a problem where when i run the following query I get
"PercentageDifference" as 99.253731343283500 all i really want to show is
99.25 but no amount fiddling seems to get it any lower or results in an
error:
select PlannedMonthName, CountOfPlannedVisits, CountOfPlannedVisitsClosed,
CONVERT(DECIMAL(12,2),nullif(CountOfPlannedVisitsClosed, 0)) /
CONVERT(DECIMAL(12,2),nullif(CountOfPlannedVisits, 0)) * 100 AS
PercentageDifference

No comments:

Post a Comment