Rank

[tatuspark]

Hi, i want to calculate the rank and i have the error as you see in the screenshot.

Thank you

[Dawid]

‘turnover’ in your window function will refer to the raw column not your derived calculation (like PostgreSQL).  You need to use either CTE or sub-SELECT