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.
P.S. The examples below did not work for me. The calculated result was incorrect.
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 )