AnsweredAssumed Answered

Profit Margin

Question asked by canoevalley on Jan 3, 2019
Latest reply on Jan 3, 2019 by canoevalley

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 )

Outcomes