How To Avoid #div 0 Error In Webi
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23, FLBOUG, Clearwater: Oct 28, ASUG Northern California: Nov 2, ASUG Arizona Chapter: Nov 3, ASUG All Texas Chapter Meeting: Nov 11. Getting error #DIV/0 Search this topic...|Search Desktop Intelligence...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Building Reports -> Desktop Intelligence Author Message bobjkbForum AssociateJoined: 19 Mar 2004Posts: 956 Posted: Fri Sep 09, 2005 6:39 amPost 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 pvsbandiSenior MemberJoined: 13 May 2005Posts: 57 Posted: Fri Sep 09, 2005 8:20 amPost subject: Re: Getting error #DIV/0 To avoid the DIV/0 error,use a if condition before the division.. =if
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java http://businessintelligence.ittoolbox.com/groups/technical-functional/businessobjects-dev-l/removal-div0-value-in-a-report-707708 Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE http://bobi.blog.com/2012/08/26/webi-report-errors/ A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon Michael Meyers-Jouan maxwellarnold how to TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus bracke Dennis Stevenson PCMag Craig Borysowich DukeGanote Richard mircea_luca iudithm Nikki Klein Clinton Jones AbhaiTripathi knowscognosdoi Iqbalyk bluesguyAZ59 COMPANIES HP, Voltage Security and ... Hitachi America, LTD Arbor Networks, Inc. Quest Software View All Topics View All Members View All Companies Toolbox for IT how to avoid Topics Business Intelligence Groups Ask a New Question Business Objects The Business Objects group is a forum where peers share technical expertise, solve problems, and discuss issues related to Business Objects. Home | Invite Peers | More Business Intelligence Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Removal #DIV/0 value in a report vishnu_ran2001 asked Apr 12, 2005 | Replies (2) Hi all, new