Re: Divide by Zero Error in MetaCube 3.1

Bruce Scott wrote: > > 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 > Try setting up a contraint on your query so that M2 is not NULL and is !=0. Of course if M2 is a floating point, you may have some problems when M2 is a very, very small number. -Mikey -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resembalence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** * Attention * -*- Due to AGIS's Refusal to Act Responsibly -*- Due to ACSI's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until they modify their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************