topic Need to Display Date Based on Ledger Value in App Development

Need to Display Date Based on Ledger Value

Lakshminarayanan_J — Thu, 29 Dec 2022 09:25:26 GMT

Hi Expert,

We need to Display Based on Ledger Value ,

For Example:

Ledger Value is Minimum Need To display Arrival Date

Ledger Value is Maximum Need to display Delivery Date

Expected Result Based on Below Table:

Need To Display Arrival date based on minimum ledger value : 28-12-2022

Need To Display Arrival date based on Maximum ledger value : 30-12-2022

Table:

BrunPierre — Thu, 29 Dec 2022 09:40:26 GMT

Min: =FirstSortedValue([Arrival Date],[Ledger Value])

Max: =FirstSortedValue([Arrival Date],-[Ledger Value])

Lakshminarayanan_J — Thu, 29 Dec 2022 10:03:00 GMT

Thank You For Your Response,

I have tried implementing for Min as you mentioned above, But is it displaying all three IDs

For ID:s22023 , we have 3 ledger value , but need to display only min , which is 1 and date as 6/18/2022 not all three values

Ledger Value	ID	=date(FirstSortedValue([Transport ATA],[Transport Ledger Order]))
1	S22023	6/18/2022
2	S22023	6/22/2022
3	S22023	6/26/2022

BrunPierre — Thu, 29 Dec 2022 11:06:07 GMT

Share the dataset with all the necessary columns.

Lakshminarayanan_J — Thu, 29 Dec 2022 11:09:46 GMT

this is the Adhoc report, primary column is ID

BrunPierre — Thu, 29 Dec 2022 12:02:33 GMT

=FirstSortedValue(Aggr(Only([Transport ATA]),ID,[Ledger Value]), [Transport Ledger Order])