I have three fields. Cost, Price and Margin. I have tried a few calculations mentioned here in this forum but with no success. The Margin field is a Number field and this is where the calculation needs to do it's thing. This is very straight forward and should be a simple fix. Any ideas would be much appreciated.

Thanks.

Bob

P.S. The examples below did not work for me. The calculated result was incorrect.

Case (

Get(ActiveFieldTableName) & "::" & Get(ActiveFieldName) = GetFieldName ( Self ) ; Self ;

If ( Sell_Cost and Cost ; ( Price - Cost ) / Cost ; "" )

)

The calculation below did not get me the results.

If ( IsEmpty ( self ) ; 1 - (cost / price) ; self )

Margin = 1 - Cost / Price