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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiplication Formula

Status
Not open for further replies.

RobbOrt

Programmer
May 27, 2010
16
US
I am a new user to crystal. I am using Crystal XI against a SQL Database.
I am trying to write a simple formula to the sales price based on quantity purchased. What I have tried is:

NumberVar SalesPrice;
SalesPrice := ToNumber({Orders_Detail.Unit Price}) * {Orders_Detail.Quantity}

I get the message "The formula result must be a boolean", But I do not want a true/false answer.
 
Is there any reason you need to use variables to do this, or to convert the unit price to a number?

What does this return:

{Orders_Detail.Unit Price} * {Orders_Detail.Quantity}


 
Thank you. I am sure I tried that and got some other message that I thought it was wrong, but it worked this time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top