This content has been marked as final. Show 11 replies
InvStatusTest.qvf 176.0 K
I have an app where I need to calculate inventorystatus per day, per product, per store. So we have an beginning inventory status and then transaction on top of that gives the current status of the inventory, so sold items are subtracted from the inventory and purchases added.
So I would like to create a column either during load or via set analysis that calculates the inventorystatus. I am having some problems with this I tried to work with something like rangesum(above(Sum(Qty),0,RowNo(Total))), but this works in someways but when I productno to it it looses track.
So any Idea on how to solve this?