ROW_NUMBER OVER (PARTITION BY ...) with a table calc

[itay_co-1643026]

Hey,

I Have table calc column of yesno type. I want to create new table calc that rank the “Yes”, I mean - the 1st “Yes” will get 1, the 2nd “yes” will get 2 and so on, while the “No” will get Null value.

How can I do that?

Thanks!