AnsweredAssumed Answered

Conditional Calculation

Question asked by droid80 on Mar 7, 2018
Latest reply on Mar 8, 2018 by droid80

Hi All

 

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.

Outcomes