Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Quantity of the last date in different dimensions

Hello,

Im struggeling with a expression.

I have to find 2 things.

The date of the last record on three dimensions, this one a managed to get.

The second thing is the quantity of this record. If there are multiple records then it has to be the last one.

This seems simple, but I can't figure it out.

I've added a sample, with some comments. I hope you guys can find it.

Thx!!

1 Reply
vgutkovsky
Master II
Master II

Try this: firstsortedvalue(StockHis.QtyAfter,-num#(replace(StockKey,Company,'')))

Regards,

Vlad