Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A | B |
5 |
- |
7 | 5 |
3 | 7 |
8 | 3 |
Column B is fetched using above() function i.e above(A)
Is there a way to get the corresponding value on first row instead of '-' i.e 5?
There is no corresponding value as there is no value of 'A' above the first row of 'B'. That said, you could use e.g. Coalesce(Above(A),A) to use A any time Above(A) is missing, or you could get fancier with if() statements and row numbers.
There is no corresponding value as there is no value of 'A' above the first row of 'B'. That said, you could use e.g. Coalesce(Above(A),A) to use A any time Above(A) is missing, or you could get fancier with if() statements and row numbers.
it worked, thanks!!!