max date

[#1]

hello,

I have a table  Doc which contains the history of stock

Doc:

nameProduct,

movementDate,

quantity,

unitPrice,

I want to get the quantity of the last movement of each product in a table

I tried this expression : sum({$<Doc.movementDate={$(=Max(Doc.movementDate))}>}Doc.quantity)

but it affects the same date for all product :s

help plz

[sushil353 · Accepted solution]

try this:

firstsortedvalue(Doc.quantity,-Doc.movementDate)

[#3]

thank u so much

[#4]

but I don't know if  it gives the the quantity of the max(mouvementDate), I mean the recent one.

[Anonymous]

hello,

Try this

sum({$<Doc.movementDate={'<=$(=Max(Doc.movementDate))'}>}Doc.quantity)