Hi everyone,
I have a problem with my set analysis. I want to find last status record like without Null
| tradedate | closedate |
|---|
| 01-Jan-2018 | 10-Dec-2017 |
| 02-Jan-2018 | 10-Dec-2017 |
| 03-Jan-2018 | - |
| 04-Jan-2018 | - |
I want my result is
| tradedate | Closedate | Closedate_Fix |
|---|
01-Jan-2018 | 10-Dec-2017 | 10-Dec-2017 |
| 02-Jan-2018 | 10-Dec-2017 | 10-Dec-2017 |
| 03-Jan-2018 | - | 10-Dec-2017 |
| 04-Jan-2018 | - | 10-Dec-2017 |
I take one more column Closedate_Fix with expression:
if(isnull(CloseDate)<>0,FirstSortedValue({< CloseDate = {'*'}>}CloseDate, -TradeDate),CloseDate)
Thanks for your help !
