topic Not getting the last updated date record using expression. in App Development

Not getting the last updated date record using expression.

Irshad92 — Tue, 30 Nov 2021 16:25:32 GMT

Dear Team,

I am using below expression to take last updated Movt_653 date for each records but not getting. could you please provide some idea on it.

tried below 2 Expression:

1.FirstSortedValue(count(DISTINCT{<Ageing_542={">0"}>} DISTINCT [/BIC/ZBARCD]),-MovT_653)

2.FirstSortedValue({<Ageing_542={">0"}>}[/BIC/ZBARCD],-MovT_653)

Results screen:

currently using this expression: count(DISTINCT{<Ageing_542={">0"}>} DISTINCT [/BIC/ZBARCD])

let me know in case of any details.

Regards,

Irshad Ahmad

edwin — Tue, 16 Nov 2021 12:09:24 GMT

why cant you use max instead of last sorted?

Irshad92 — Wed, 17 Nov 2021 04:21:02 GMT

Dear Edwin,

I tried using max also, but not getting the expected value.

using max expression:

count({<Ageing_542={">0"},MovT_653={"$(=max(MovT_653))"}>} [/BIC/ZBARCD])

Regards,

Irhsad Ahmad