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 SkipVought 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
0
0
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