Need help with a variable
I ahve a report that I want to show Free to Sell stock - stock that is in the warehouse that hasn't been allocated.
I have created a variable called Freestock which basically uses a Physical Stock quantity minus the allocated stock quantity.
It is currently just adding all the figures together, instead of splitting it by item, so this is wrong
Here's the formula I'm using ;
=Sum(<Warehouse Physical Quantity>-<Outstanding Allocated Quantity>)
Any help would be greatly appreciated in getting this sorted
Thanks in advance