Stock inventory cuurent Value

[bohravanraj]

Hello folk,

i am having a following table

itemcode	qnty	itemcost	date
1	5	10	10/1/2014
2	10	12	10/2/2014
1	5	15	10/3/2014
1	5	18	10/4/2014

and i want to generate a following report

itemcode	qnty	itemcost	Current Inventory value
1	15	18	270
2	10	12	120

the report will take the cost of maximum of date for every itemcode and should calculate inventory stock according to that code.

Thanx

[maxgro · Accepted solution]

Current Inventory value

FirstSortedValue(itemcost,-date) * sum(qnty)

[bohravanraj]

Thanx Massimo Grossi