I have a query which generates a table of trials and values from a database (example pic below)

`SELECT * FROM [ReMetrica].[ReMetrica_Result].[GetTrialValuesAsDouble] ('BD5E92F3-3A3B-43B4-BC22-409F34CE5980', 'Total', 'Net Loss', 1) `

which is an expression we’ve been given with this bit of software.

I can calculate the mean of all these trials by using:

`SELECT avg(Value) FROM [ReMetrica].[ReMetrica_Result].[GetTrialValuesAsDouble] ('BD5E92F3-3A3B-43B4-BC22-409F34CE5980', 'Total', 'Net Loss', 1) `

However I’m trying to extend this to calculating percentiles as well with

`SELECT percentile_cont(Value) OVER [ReMetrica].[ReMetrica_Result].[GetTrialValuesAsDouble] ('BD5E92F3-3A3B-43B4-BC22-409F34CE5980', 'Total', 'Net Loss', 1) `

which doesn’t work due to an ‘incorrect’ syntax after OVER. Could someone help me with where I’m going wrong?