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

Crystal Reports Formulas

Status
Not open for further replies.

rechless

Technical User
Jan 12, 2012
3
US
I am running Crystal 11 and need to create a formula that will say if the amount is a "withdrawl" or "contribution" based on a net amount. Example "if {@NET MOUNT} is "positive" then "contribution" or if {@NET AMOUNT} is "negative" then "withdrawl". Can anyone help me creat a formula like this? I would be very grateful!!

rechless
 
I do not have crystal in front of me, so apologize if i have any typos or missed something, but maybe something like this:

IF {@NET MOUNT} > 0 then "contribution"
else
IF {@NET MOUNT} < 0 then "withdrawl
 
Thanks for the response. That is pretty much the formula I used and it seems to work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top