Forum Discussion
vangashiva
Dec 29, 2020Copper Contributor
Stock Deduction for Sale Order Item
Item SO ID SO Qty Stock Difference A A123 10 12 0 B A124 5 5 0 A A125 7 12 -5 I'm unable to perform operation in excel for stock inventory. As above table, Item A...
vangashiva
Dec 31, 2020Copper Contributor
I cannot subtract directly as multiple times it will repeat the value. I like to display row wise difference which is not happening. In real practical scenario, there will be multiple columns available apart from above table.
Please suggest some solution.
mtarler
Dec 31, 2020Silver Contributor
vangashiva Sorry I don't know what you are looking for. We need more information. Maybe attach a sample sheet. What you have said just isn't enough for me to understand.