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 for Peachtree Complete 2003

Status
Not open for further replies.

vree

IS-IT--Management
Dec 31, 2002
49
US
Crystal Reports VS 8
Peachtree Complete 2003

I have a report that is working well, showing a GL account amount field for a particual GL, I would like to show the field twice, one amount for credits (<0) and one amount for debits (>0)

I have not been able to get the formula right? Could someone help?

it is jrnlrow.amount

i would appreciate it.
 
You could create two formulas as follows:

for {@credit}:

if {table.amount} < 0 then {table.amount} else 0

for {@debit}:

if {table.amount} > 0 then {table.amount} else 0

-LB


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top