This content has been marked as final. Show 4 replies
I did this before, lost the file, and cannot remember how I did it.
I have 2 values for field Type
In the attached file I'm missing something (obviously) as I'm finding 2 last dates according to Type, 1 for Plan and 1 for Actual (and yes I know that's the way FIXED is supposed to work).
However, I want to determine the last date posted as Actual and assign that value to all records, Plan and Actual.
In the attached workbook I'd like the field "Last Date" to contain a unique value determined by the last posting with a Type of Actual, in this case May 1, 2018, and have that value assigned to all records regardless of Type.