| Status_Desc | Status Date | System Date | | Returned | 08.04.2025 08:02 | 08.04.2025 15:24 | | Delivered | 02.04.2025 16:58 | 08.04.2025 15:24 |
I want to display the Staus_Desc based on Last inserted System date
=FirstSortedValue(STATUS_DESC,-STATUS_DATE)
This does not give any results as the system date is same for both the lines.. If there are two entries with same System date, do we have any option to show any one of the Status_desc. Or please suggest an alternative to achieve this.
