Last status record without NULL

[phongnnguyen]

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 !

[sunny_talwar]

May be this

If(IsNull(CloseDate), FirstSortedValue(TOTAL {<CloseDate = {'*'}>} CloseDate, -TradeDate), CloseDate)