FirstSortedValue - should I use it?

[PescheSwitzerland]

Dear Folks 🙂

I have the field "Stock_Amount". And for every day I have this value in a table, but it comes with a key: 6_26.06.2024. What I want is, that I see for every product the current Stock_Amount.

What would you suggest?

Thanks a lot!

[hic · Accepted solution]

Sounds as if you should.

Try
FirstSortedValue(Stock_Amount,-Date)
with "Product" as dimension. Note the minus sign.

If you don't have the "Date" field, I suggest you create it in the script using
Date#(SubField(Key,'_',2),'DD.MM.YYYY') as Date