CASE WHEN x.test = 0 THEN 'N/A' WHEN compliance > 100.0 THEN '100.0'
-- CAST(FLOOR(compliance *10)/10.0 AS DECIMAL(3,1))) END as [Compliance]
CAST(FLOOR(compliance *10) / 10.0 AS DECIMAL(6,1))) END as [Compliance]
1) Error occurs only for a certain inputs, not for all.
2) Compliance column has to accept nvarchar and float. If there is no compliance, we set the value to be 'N/A'. if there is compliance it could be .. 98.9% or etc .. by making sure that they dont exceed 100%
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.