Hi All,
I have a table structured like
I would like to create a new calculated field called Pilot that would be derived from New with the conditon that for every ID and Field_Name and the altest Time there should be only one Pilot
the new table should look like this -
Any suggestion would be appreciated. Thank you
Attaching the sample file.
Regards,
RS
3 respostas
Try the following calculated field:
Pilot
// Get the max date/time for each ID and action.
// Then, based on that, get the value of New.
// Use an LOD to get this max value of New.
{FIXED [ID], [Field Name]: MAX(
IF [Create Time] = {FIXED [ID], [Field Name]: MAX([Create Time])} THEN
[New]
END
)}
