I’d like to calculate a value of arrived-quantity from the order table, which are 5 columns, OrderID, Item, SKU, OrderQuantity, and ArrivedQuantity.
I’ve used select() of functions, something like this:
order[arrived-quantity],([SKU] = [_ThisRow].[SKU])
It’s worked. But there was something wrong when I added more than 2 records.
i.g. I ordered 5 apples with OrderID column of ABC and I received 5 apples in the first time, OrderQuantity is 5 and ArrivedQuantity is 5, the select() of functions solves the problem perfectly.
When I added the second record, the problem has happened. I ordered the same item and quantity with OrderID column of DEF, OrderQuantity is 5, but ArrivedQuantity is coming to 10.
I tried editing the select() to like this:
([SKU] = [_ThisRow].[SKU]),
([OrderID] = [_ThisRow].[OrderID])
but it doesn’t work anyway.
I want my ArrivedQuantity’s result can be separated by OrderID. Anybody can help me to do that? I will appreciate it.