Message
From
27/03/2000 13:28:48
John Baird
Coatesville, Pensilvânia, United States
Coatesville, Pensilvânia, United States
To
27/03/2000 13:13:44
Mike Yearwood
Toronto, Ontário, Canada
Toronto, Ontário, Canada
General information
Fórum:
Visual FoxPro
Category:
Programação, sintaxe e comandos
Título:
Miscellaneous
ID da thread:
00350796
ID da mensagem:
00350863
Views:
19
>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
I've already tried that. What is happening is:
Assuming 2.00 cost and 8.00 price, the formula calculates the margin at 75%.
Assuming 2.00 price and 8.00 cost, the formula says its -300%.
Shouldn't that be -75% in the second or am I not understanding the process or the math?
>
>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
I've already tried that. What is happening is:
Assuming 2.00 cost and 8.00 price, the formula calculates the margin at 75%.
Assuming 2.00 price and 8.00 cost, the formula says its -300%.
Shouldn't that be -75% in the second or am I not understanding the process or the math?