Cannot use Oracle function round(ratio_to_report(count(*)) over(partition...in my jasper sql query

[sottersen]

I have a query that includes the following function call: round(ratio_to_report(count(*)) over(partition by oh.parent_organization_id) * 100,2)||'%' percentage
It runs fine in SQL Developer but will not compile when I attempt to include it in my sql query in the reporting tool. Is there something I need to do to allow Jaspersoft Studio to recognize the function? Please advise.

[sottersen]

it seems that even though the query shows an error, the sql will still run and return the desired results

[sottersen]

it it seems that even though the query shows an error, the sql will still run and return the desired results