I am wanting to create a calculation.
I have an 'Inventory' app and an 'Enter Stock' app which a linked by a relationship. The inventory app is the database where the products details and quantity are kept and the 'Enter Stock' app is the functional app where we will input details to increase or decrease stock levels. The 'Enter Stock' app has the following fields:
"Product" (Relationship Field)
"Enter Action": 'New Stock' and 'Outgoing Stock' (Category Field)
"Quantity" (Number Field)
I would like to create a calculation in the 'Inventory' app for quantity on hand which increases or decreases the quantity depending on which category is selected ie New Stock increases quantity and Outgoing Stock decreases quantity. The quantity to increase or decrease will be the amount provided in the 'Quantity' number field.
I have tried different solutions but haven't been able to return results.
Thanks in advance for your help! :-)
Please sign in to leave a comment.