Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Current Inventory value
FirstSortedValue(itemcost,-date) * sum(qnty)
Thanx Massimo Grossi