Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Math Formulas in one Formula Field 1

Status
Not open for further replies.

flagurugrl

Technical User
Nov 3, 2005
32
US
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!
 
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


 
Oh Yeah I forgot to mention that I am using Crystal 10
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top