Producing the Statistic out of a SQL Server User experience monitor

I am not a SQL expert this query only prints out 1 value what does the format look like of the statistic command. Statistic: ???? There is no example I can find on the SolarWinds Guides. 

It just has to be a numeric int, single column with a single row return if no message... but have you tested your sql query in something like SSMS, or Orions Database Manager (I see its querying the SolarWinds database it appears)

Knowing that I usually force it to a SELECT TOP 1 so there's no way it will return more if there's the chance it could.

Yes I have run it in MSQL Server Management the Query puts out the Statistic label and one number

Statistic: ???? is used in Powershell. I don't think it matters what you name the column in SQL.

For a SQL query the Statistic is simply the first column returned and you can optionally also return a second column which is the Message. 

I haven't tested this but I have a theory that this may be syntax related. Lots of things you can do in native SQL / SSMS aren't always permitted inside various functions in SolarWinds.

It may be worth structuring the query with proper SELECT X FROM Y format with what you have as a subquery.

Something like:

SELECT TOP 1 ROUND(X.Statistic * 100, 2) AS [Statistic]
FROM (<ExistingQuery>) AS X

documentation.solarwinds.com/.../sam-sql-server-user-experience-monitor-sw3308.htm

I've added the changes does not like the divide and other syntax. The number is being produced when I do a retrieve just not printing out. See attached:

With Mods just t show:

With Mods just t show: