Change KPI Output to Read as a Percentage with Decimals

JCALD6

Hello,

I have the following SWQL Query that I have modified from a previous post so that it creates a KPI output. However, the output reads as a rounded integer. I would prefer if the output would read "99.35%" for example. Can someone assist in modifying my query to make that output read that way? Thanks in advance! 

SELECT
Avg([data].[ContainerStatus].PercentAvailability) as [Average Percent Availability]
, Case
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 1 Then 'Jan'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 2 Then 'Feb'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 3 Then 'Mar'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 4 Then 'Apr'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 5 Then 'May'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 6 Then 'Jun'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 7 Then 'Jul'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 8 Then 'Aug'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 9 Then 'Sep'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 10 Then 'Oct'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 11 Then 'Nov'
When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 12 Then 'DEC'
Else ''
End as [Month]

FROM orion.groups AS data
WHERE
([data].[CustomProperties].[Business_Unit_Groups]) = ('X')
And MONTHDIFF( DateTrunc('Month', [data].[ContainerStatus].DateTime), Getdate() ) < 2

Current Output: 

jm_sysadmin

Now that I think about it you force it out of an int to a decimal by multiplling by a decimal like:

Avg(([data].[ContainerStatus].PercentAvailability)*1.00) as [Average Percent Availability]

That would need to be rounded to get 2 decimals to match your example. 

Round(Avg(([data].[ContainerStatus].PercentAvailability)*1.00), 2) as [Average Percent Availability]