Divide by Zero Error in MetaCube 3.1
Posted in 1998
Topics: General Discussion
This is a multi-part message in MIME format. --------------B57E5A3CF15D098557B49A50 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there an alternative way of avoiding the "divide by zero " error without using a constraint (measure > 0). My query is calculating the percentage of one measure to the other (M1/M2) for several measure pairs to appear in one report. Since my query consists of additional measures, using constraints eliminate valid rows if at least one of the conditions of the constraints is met. Thanks, Bruce --------------B57E5A3CF15D098557B49A50 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Bruce Scott Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Bruce Scott n: Scott;Bruce org: Aames Financial Corp. adr: 350 S. Grand Ave;;;Los Angeles;CA;90071;USA email;internet: bruce.scott@mci2000.com title: Business Analyst/Database Adminstrator tel;work: (213) 640-4762 tel;fax: (213) 640-4527 x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------B57E5A3CF15D098557B49A50--