Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this:
firstsortedvalue(Doc.quantity,-Doc.movementDate)
thank u so much
but I don't know if it gives the the quantity of the max(mouvementDate), I mean the recent one.
hello,
Try this
sum({$<Doc.movementDate={'<=$(=Max(Doc.movementDate))'}>}Doc.quantity)