I am pretty new to filmmaker and have hit a small bump in the road.
I have three fields "Quantity", "Unit Price " and " Net price"
I have a calculation in the "Net price" field ; ( Quantity * Unit Price ) which gives me the total and works great. What I cannot seem to wrap my head around is having a calculation in "Unit Price " that will calculate the unit price if a total is entered instead of a unit cost. It seems I can only have an either or situation and cannot get both calculations to work.
I hope this makes sense. I have attached a screen grab if it helps.
Thanks for any help.