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