Crystal Reports Divide Formula

What's the fastest way to generate a 1 GB file containing only random numbers? By joining you are opting in to receive e-mail. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. See more: VB VB.NET Hi All, I am creating one crystal report.

Not the answer you're looking for? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ Covered by US Patent. Who is - domain name info Google Page Rank Checker Password generator Screen colour picker How to convert to MP4 and compress videos WCAG Colour Contrast Analyser Topics Apple Mac Tips

Instead of: {fielda} / {fieldb} Check it first: If {fieldb} = 0 then 0 else {fielda} / {fieldb} Good luck! his comment is here All I want is to get that 79.89% and 53.45% total. Powered by Blogger. current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list.

If {Command.exec_broker} = 'ecut'then {#RTotal3rdPartySoft} / {#RTotal3rdPartySoftTarget} * 100 Else if {Command.exec_broker} = 'igrp'Then {#RTotal3rdPartySoft} / {#RTotal3rdPartySoftTarget} * 100 Else if {Command.exec_broker}= 'inca'Then {#RTotal3rdPartySoft} / {#RTotal3rdPartySoftTarget} * 100 Can Mage Hand wield a Shield? This happens, obviously, when a calculation tries to divide te number zero.And since we all know that underlying data cannot be trusted 100%, it is necessary to test for these zero this contact form Here you'll find all of our prior GoldMine, Microsoft CRM, Quickbooks, HEAT and Crystal newsletter tips as well as links to my columns in Forbes and Businessweek and other announcements.Please visit

Maybe with a little source... Please any one advice me Thanks in advance Sucharitha Posted 31-Dec-12 1:48am RagSuchi683 Add a Solution Comments ChrisTopherus 31-Dec-12 6:52am Can you be a bit more precise? Join our community for more solutions or to ask questions.

Privacy Policy Site Map Support Terms of Use Skip to content Search for: IT Support Guides Menu Home Latest comments Tools and resources What is my IP?

Login. If you are adding values to get the divisor and one of those was NULL then you might get 0 as the divisor. How do I clean it up? Let's work to help developers, not make them feel stupid.

When I have the division by 0 error rear its ugly head, I will change the formula to:if myfield1 = 0 then 0 else if myfield2 = 0 then 0 else Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Can any of the values be NULL? September 24, 2013 at 10:01 PM xumeiqing said...

In it, you'll get: The week's top questions and answers Important community announcements Questions that need answers see an example newsletter By subscribing, you agree to the privacy policy and terms mlmcc 0 LVL 34 Overall: Level 34 Crystal Reports 33 Message Active 1 day ago Expert Comment by:James06282011-04-15 Comment Utility Permalink(# a35399763) That's why I said to create a new When looking at the report, the formula generating the error message was in the format:= {Tablename.Fieldname1}/{Tablename.Fieldname2}When creating formulas, that use a division operator, it is always advisable to consider the possibility this way, if the null condition is true, then the value is 0, and the fractional measurement only comes to pass if there is a number in your denominator.

I may design my report in June of a year and at that time all the formulas have data in them so they don’t get this error. Join UsClose Not endorsed by or affiliated with SAP Register| Login Follow BOB on Twitter! (Opens a new window) Index|About Sponsors| Contact Us| Calendar| FAQ| Rules and Guidelines| Privacy GIMP Images and Photos Web Graphics Software Xpdf - PDFtoPNG - Command Line Utility to Convert a Multi-page PDF File into Separate PNG Files Video by: Joe In this sixth video Insults are not welcome.