[Feature Request] Add ignore/respect nulls argument for percentileRank, similar functions

In current state, percentileRank treats NULL values as some value less than 0.
I’ll use this set as an example: [NULL, 0, 1, 2, 3]

Intuitively, this set would be ranked ASC as [NULL, 0, 25, 50, 75]
In current state, it would be ranked ASC as [0, 20, 40, 60, 80]

I’d like an optional argument to be added to percentileRank (and any other similar functions) to either ignore or respect nulls

Hi @nichbenn,

Thank you for posting.

I will add this as a feature-request

Regards,
Demola