Hubert-Dudek
Databricks MVP

Please just replace OVER with

IGNORE NULLS OVER


My blog: https://databrickster.medium.com/