Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have table with duplicates values (date values). i need to get the status of the latest date for the transaction.
example of the dataset:
transactionId TransactionNumber Status DateOfLastReferral
1 12332 submitted 13/01/2021
2 33245 exported 13/04/2020
3 76753 submitted 14/01/2021
4 12332 saved 13/01/2021
------
it should print :-
transactionId TransactionNumber Status DateOfLastReferral
1 12332 submitted 13/01/2021
2 33245 exported 13/04/2020
3 76753 submitted 11/01/2021
4 12332 saved 13/01/2021
i tried to use FirstSortedValue(Status, -DateOfLastReferral, 2) but giving me null values in status field with duplicates rows.
transactionId TransactionNumber Status DateOfLastReferral
1 12332 - 13/01/2021
2 33245 exported 13/04/2020
3 76753 submitted 11/01/2021
4 12332 - 13/01/2021
Thanks in advanced!
check out this app
it did work but it did not delete the records, still showing the records with zeros as null. i want to remove the null records from the table. how i can delete these records ?
this is what i used:
=if([TransactionId]=max(total <TransactionNumberFormatted> [TransactionId]),[TransactionId])