>Hi John
>
>I'm neither an economist nor a mathematician. Exposure to business and accounting systems may be enough. Assuming the margin is the difference between the cost and the sales as a percentage of the sales price, doesn't this work?
>
>abs(tnPrice-tnCost)/tnPrice*100
>
>HTH

Hi Mike,

I admit I was a little stumped by what John is looking for. I thought about the ABS() possibility but that seemed so trivial that he would have thought of it. I figured there were some other issues/factors involved here in a negative case situation which is why I was probing for more info. Hopefully this will fix it for him.

Bill