Calculating Quantity in Stock - Kgs
In the following statement, the value of Quantity
in Stock - Kgs for DaysOld element 1 is calculated.
['1','Quantity in Stock - Kgs']= N:DB('Purchase',!FishType,'Total Markets',!Date,'Quantity
Purchased - Kgs');This statement says that for any given fish type on any given date, the value of Quantity in Stock - Kgs for DaysOld batch 1 is calculated by retrieving the value of Quantity Purchased - Kgs for Total Markets from the Purchase cube.
