OQL Query, using over and devide

0
Do anyone know if I can use Over() in oql query from a report.  Mendix does not like over() and / ()devide SELECT dep,          COUNT (*) as theCount,        sum(count(*)) over()  as total_cnt,          round(100*(count(*) / sum(count(*)) over ()),2) as  ...
asked
1 answers
2

By my knowledge over() is not a available function. Divide is 

:

in OQL, see https://docs.mendix.com/refguide6/oql-operators

complete reference:

https://docs.mendix.com/refguide6/oql 

answered