Re: Divide by Zero Error in MetaCube 3.1

On Tue, 10 Mar 1998 20:46:40 GMT, Bruce Scott <bruce.scott@mci2000.com> wrote: >This is a multi-part message in MIME format. >--------------B57E5A3CF15D098557B49A50 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit If you got rid of this MIME format it would be nice. >Is there an alternative way of avoiding the "divide by zero " error >without using a constraint (measure > 0). You could create a stored procedure that did the division for you and include that in your select statement. It would test for 0 end return whatever you wanted in that case. >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. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: Primary with ODBC info: http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html