Last Reporting Date

I am trying to ensure that the "Last Reported Date" always shows the max date for the last LASTNONBLANK. In the example below you will note this should be 9/30/2020 but I have an account with 12/31/2...