Home » Developer & Programmer » Reports & Discoverer » Divide by 0 Problem...Kindly Help.
Divide by 0 Problem...Kindly Help. [message #88814] Sun, 06 April 2003 03:29 Go to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Hi Experts,

I am getting an error i.e., 0 divide something if I will give this below formula in Reports and it is not proceeding further.

Select Itemcode,(Qty/AVG) DAYS from Sales

Kindly help in solution.

Thanks,
Syed Muzzammil.

Report message to a moderator

Re: Divide by 0 Problem...Kindly Help. [message #88979 is a reply to message #88814] Tue, 15 July 2003 07:30 Go to previous message
Rahman
Messages: 40
Registered: July 2003
Member
A.A.W.W
write ur statement as below
Select Itemcode,(Qty/decode(AVG,0,1,AVG)) DAYS from Sales
try this
bye
rahman

Report message to a moderator

Previous Topic: Language settings in Oracle Reports to Run in Arabic Chars.
Next Topic: *****A tool for reports in HTMLCSS format , I thank it is useful
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 22:03:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.