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

error in formula 1

Status
Not open for further replies.

hpsingh

Programmer
Feb 27, 2002
13
IN
I want to add a formula field named dr and I have given the following coding in the window but it is giving error when I click at save. Anyone who can help is welcome.
{@dr}={bk_transact.Amount} where {bk_transact.tran_type}="DR"
 
You don't name the formula inside the formula, you name it when you create it and then define the calculation:

if {bk_transact.tran_type}= "DR"
then {bk_transact.Amount}
else 0 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top