Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Have Data
I want to show MAE_Type at Max(MAE_CreateDate)
I tried but it's not correct :
Not sure the idea why you want to show Max. Anyway, since this filed contains string, Maybe
MaxString(MAE_CreateDate)
I want to display the latest MAE_Type. can see it from MAE_CreateDate.
EX FT_ID = 20110324 The latest MAE_Type is Dismantle.
I tried
The displayed value is correct.
However, if FT_ID is not selected, the value will not be displayed.
Can you please provide more details like expected output table i.e expected columns and are you expecting to display only the latest date for FT_ID with latest MAE_Type.