Firstsortedvalue

[master_student]

Hello

here's my table

I need to get the row with the max(valid_from) date

I use this expression : Firstsortedvalue(msis,-Aggr(max(valid_from),msis)) and this is the result :

Any idea please?

Thanks

[annafuksa1]

can you upload your app ?

[master_student]

I attached it in my first request

[vishsaggi]

Try this?

[master_student]

Thank, will try and let you know