BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Nov 1.

Getting error #DIV/0


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
bobjkb
Forum Associate
Forum Associate



Joined: 19 Mar 2004

Posts: 956


flag
PostPosted: Fri Sep 09, 2005 6:39 am 
Post subject: Getting error #DIV/0

Hi all

If we divide a number with zero then we get #DIV/0.
I followed the formula using the IsError, then and Else statement and I was able to get rid of the error.
But it looks like the result is not a number anymore.
I use the ToNumber function after that but if I do that, I'm getting the error again.
How do you divide a number that the result will be zero or null value.

THanks in advance
B...
Back to top
pvsbandi
Senior Member
Senior Member



Joined: 13 May 2005

Posts: 57



PostPosted: Fri Sep 09, 2005 8:20 am 
Post subject: Re: Getting error #DIV/0

To avoid the DIV/0 error,use a if condition before the division..
=if <Denominator> <> 0 then <Numerator>/<Denominator>
then you can format those cells where you have the denominator=0..
Hope this helps..
Sarma.
Back to top
Lachase
Senior Member
Senior Member



Joined: 06 Sep 2005

Posts: 57



PostPosted: Fri Sep 09, 2005 11:09 am 
Post subject: Re: Getting error #DIV/0

Not only that use IF ISNULL(<Denominator>) then 0 else formula.
Back to top
digpen
Forum Addict
Forum Addict



Joined: 15 Aug 2002

Posts: 2854
Location: Building the next big thing...


flag
PostPosted: Sun Sep 11, 2005 11:39 am 
Post subject: Re: Getting error #DIV/0

You should be using something like:

Code:

=IF ISERROR(<Num>/<Denom>) THEN 0 else <Num>/<Denom>


Alternatively:
Code:

=IF <Denom>=0 THEN 0 else <Num>/<Denom>
Back to top
Jason Katakura
Senior Member
Senior Member



Joined: 15 Aug 2002

Posts: 49
Location: Huntington Beach, CA - Honolulu, HI


flag
PostPosted: Mon Sep 12, 2005 1:44 am 
Post subject: Re: Getting error #DIV/0

Omit the ELSE clause to return null values in the case of errors. Here's a previous post

http://www.forumtopics.com/busobj/viewtopic.php?t=16512&highlight=
Back to top
pavani4
Principal Member
Principal Member



Joined: 15 Jun 2010

Posts: 101



PostPosted: Tue Feb 15, 2011 1:46 pm 
Post subject: Re: Getting error #DIV/0

pvsbandi wrote:
To avoid the DIV/0 error,use a if condition before the division..
=if <Denominator> <> 0 then <Numerator>/<Denominator>
then you can format those cells where you have the denominator=0..
Hope this helps..
Sarma.


Hi ,
Even I m facing the same issue;

But i dont want to format the report. Instead it should do by itself on providing run time parameters. I want #div/0 with either '0' or NULL or hiding row.
Back to top
Karachiite
Forum Member
Forum Member



Joined: 12 Apr 2013

Posts: 17



PostPosted: Wed Sep 07, 2016 5:17 am 
Post subject: Re: Getting error #DIV/0

Perfect, first solution by digpen worked for me. great stuff icon_biggrin.gif
Back to top
StinksatWebi
Forum Member
Forum Member



Joined: 25 Jun 2015

Posts: 2



PostPosted: Wed Oct 19, 2016 2:48 pm 
Post subject: Re: Getting error #DIV/0

=IF <Denom>=0 THEN 0 else <Num>/<Denom>

DigPin this worked great thanks!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0518 seconds using 17 queries. (SQL 0.0174 Parse 0.0014 Other 0.0330)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo