Not getting the last updated date record using expression.

[Irshad92]

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]

why cant you use max instead of last sorted?

[Irshad92]

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