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

Division By Zero 1

Status
Not open for further replies.
brecat77

brecat77

IS-IT--Management
Feb 27, 2008
28
US
Some help would be extremely appreciated. Her is the formula i have

(1 - (Maximum ({invoice_line.unit_price}, {invoice_line.item_id}) / {p21_view_inv_xref.last_price_paid})) * 100
 
Sort by date Sort by votes
You might try
If {p21_view_inv_xref.last_price_paid} > 0 then
(1 - (Maximum ({invoice_line.unit_price}, {invoice_line.item_id}) / {p21_view_inv_xref.last_price_paid})) * 100
else 0
 
Upvote 0 Downvote
Worked like a charm. Thank you so much
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
457
bbranco
bbranco
Sherry B
  • Locked
  • Question
Crystal division by zero using if in
Replies
12
Views
681
SkipVought
S
anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
437
anandm19
anandm19
crystaldev1
  • Locked
  • Question
Sorting a field by combining main and subreport
Replies
3
Views
304
hilfy
hilfy
rickm140
  • Locked
  • Question
last sale (or most recent sale) greater than zero
Replies
1
Views
176
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top