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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show number as positive however the number is subtracted in the total?

Status
Not open for further replies.
Zthomas

Zthomas

IS-IT--Management
Joined
Feb 7, 2006
Messages
9
Location
US
Hi

I am trying to show a number as positive but have it be subtracted in the total?

 
Sort by date Sort by votes
Is the number held on the database as positive or negative? If so, total it as such. Display using a formula fields:
Code: 
 if {value} < 0 
then {value} * -1
else {value}

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
425
DjangMan
DjangMan
G
  • Locked
  • Question Question
Multiple groups in same level
Replies
0
Views
350
george1610
G
K
  • Locked
  • Question Question
We're using command in crystal report
Replies
1
Views
778
hilfy
hilfy
JustMe24
  • Locked
  • Question Question
How to select from 2 rows in a table
Replies
1
Views
721
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
1K
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top