Hi guys, I am following the inventory management app tutorial. Yet when reaching the Step 3: Calculate the real-time inventory level I have to provide a formula to see the current inventory level of each item in our app. The calculation formula is pretty simple:
Current stock level = initial stock + stock in – stock out
But when I want to tell our app how to calculate the inventory level, I go to Data>Columns and in the “Products” table select Add virtual column and add this app formula in the popup box:
COUNT([Related Purchases]) - COUNT([Related Sales]) + [Initial Stock].
But it tells me there are no
related purchases, nor