Multiple Math Formulas in one Formula Field 1

[flagurugrl]

Hi All,
I am a newbie using crystal so please don't laugh if this seems simple.... I want to take 1value - 2value * 3value and place the result in a field called open value... I used the "formula Workshop" and when I check the formula its ok but when I refresh the report data it returns a wrong answer.....

All three values are numbers... the 1st 2 are regular numbers and the 3rd is currency... please tell me what I am missing

formula = {OpenOrders.QuantityOrdered_3} - {QuantityShipped_3} * {ExtensionAmt_3}

THANK YOU IN ADVANCE!

 

[lbass]

I think you need to add parens around the appropriate fields. Using Crystal syntax, I'm guessing you want:

({OpenOrders.QuantityOrdered_3} - {QuantityShipped_3}) * {ExtensionAmt_3}

-LB

 

[flagurugrl]

Oh Yeah I forgot to mention that I am using Crystal 10