Home » Developer & Programmer » Reports & Discoverer » division by zero
division by zero [message #88524] Mon, 28 October 2002 11:54 Go to next message
ron
Messages: 50
Registered: July 1999
Member
How can I prevent 'division by zero'?
thanks for any help

Report message to a moderator

Re: division by zero [message #88525 is a reply to message #88524] Mon, 28 October 2002 21:11 Go to previous message
Amit Sheth
Messages: 3
Registered: October 2002
Junior Member
use the decode function as:

decode(col name, 0, 0, col name1/col name)

this will prevent the "divide by zero" error by substituting the erroneous value by zero.

regards,

Report message to a moderator

Previous Topic: help about the Report
Next Topic: Report in Urdu language
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 13:12:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.