### MDX Measure Expression Syntax divide by a number

using the calculated measure, did you substitute your measure name ( [Measures].[OPEN DURATION] ) for the placeholder ( [Measures].[Value To Divide] )? could you show us the query you tried?
| 4 Replies | 8176 Views | Created by AZ Vick - Thursday, May 29, 2008 9:36 PM | Last reply by crazy888s - Friday, May 30, 2008 4:40 PM

### Divide in SQL

,pub.PublicationID, pub.Name Order By p.PartnerName, pub.Name ASC I have this query i want to divide the 2 by the value 'NumberOfDocuments \ 2' like so, i get a syntax ...
| 2 Replies | 4401 Views | Created by Tryin2Bgood - Tuesday, September 15, 2009 1:06 PM | Last reply by Rajesh Jonnalagadda - Tuesday, September 15, 2009 1:19 PM

### =IIF Expression returns divide by 0 error when calculation should not be done.

I'm trying to avoide dividing by 0 with the follwing expression. =IIf(Fields!ly_rev.Value<>0,((Fields!ty_rev.Value-Fields!ly_rev.Value)/Fields
| 1 Replies | 5248 Views | Created by hics0 - Wednesday, July 1, 2009 6:20 PM | Last reply by hics0 - Wednesday, July 1, 2009 6:40 PM

### Dividing by Zero

Hello, You can't divide by 0, it will result in an error which can be caught with a TRY/CATCH. You'll have to decide, or ask the business, how ...
| 3 Replies | 2652 Views | Created by SQL Server 2008 case statements - Wednesday, October 17, 2012 1:31 PM | Last reply by Sanil Mhatre - Wednesday, October 17, 2012 7:29 PM

### Re Attemted to divide by zero error in SSRS Expression

It is because your expression  IIF(Max(Fields!Year1Starts.Value)=0,1,Max(Fields!Year1Starts.Value)) must be returning 1 here hence 5/1 =500%. if you ...
| 3 Replies | 603 Views | Created by Aruna2015 - Monday, February 6, 2017 10:13 AM | Last reply by Pragati Sharma - Monday, February 6, 2017 3:17 PM

### divide by zero

if you are dividing by zero and in that case if it is giving you #Ind Error or goes in infinite loop then in that case you can handle it as; IIF([Measures].[number
| 3 Replies | 8665 Views | Created by Nina0702 - Wednesday, May 6, 2009 3:35 PM | Last reply by Aniruddha Thengadi - Wednesday, May 6, 2009 5:48 PM

### Dividing a Column

First Name and Surname are dummy column names in table 1 therefore I cannot create a join on table 2.   However I have created a ...
| 13 Replies | 6093 Views | Created by system243trd - Tuesday, December 5, 2006 10:46 AM | Last reply by Gurpreet Singh Gill - Tuesday, December 5, 2006 11:39 AM

### convert and divided

what I am getting here is 0.7654000000 what I need is just 0.7654 You could add another CAST or CONVERT around the entire ...
| 8 Replies | 524 Views | Created by coool_sweet - Friday, August 11, 2017 11:04 PM | Last reply by Erland Sommarskog - Saturday, August 12, 2017 3:33 PM

### Dividing by Zero

I am trying to create a case statement that will allow me to divide by zero and then turn into a percent  I am wondering what else I need to do to make that ...
| 3 Replies | 2185 Views | Created by SQL Server 2008 case statements - Wednesday, October 17, 2012 2:14 PM | Last reply by Gautham Kamath - Wednesday, October 17, 2012 4:09 PM

### Divide two columns based on another column expression ssrs

I am trying to sum two columns and divide them based on values from another column in an expression. No matter how I write it I get an error. I have to do it on the front-end and not ...
| 4 Replies | 807 Views | Created by Programmera12b3c - Wednesday, February 13, 2019 9:35 PM | Last reply by Mitarai Queen - Friday, February 15, 2019 1:59 AM

### operator DIVIDE

You are right. There is no clause such UNION, INTERSECT, etc. But In that article Celko expressed its implementations.  sqldevelop.wordpress.com
| 10 Replies | 1054 Views | Created by Anna1313 - Tuesday, December 10, 2013 8:28 PM | Last reply by Naomi N - Monday, December 30, 2013 11:26 PM

### Calculated member treats NULL's as zeros.

Hi there, I'm trying to make a calculated member to display the result of dividing one value by another which shows the variance percentage between ...
| 5 Replies | 6505 Views | Created by ChrisR_NZ - Sunday, August 19, 2012 10:34 PM | Last reply by ChrisR_NZ - Monday, August 20, 2012 1:04 AM

### Dividing with membername

, for pure performance and ability to cache etc. why not create a measure group dimensioned by the "Logistics" that stores the truck size as a measure. You can then divide one by ...
| 4 Replies | 3860 Views | Created by Naquer - Monday, April 19, 2010 10:49 AM | Last reply by Naquer - Monday, April 19, 2010 1:05 PM

### SSIS Divide by zero error

Hello I have a SSIS package that errors of my Derived Column with a divide by zero error. I have a Derived Column before the one that errors that sets ...
| 2 Replies | 1746 Views | Created by SQLSearcher99 - Thursday, December 14, 2017 11:37 AM | Last reply by SQLSearcher99 - Thursday, December 14, 2017 12:42 PM

### divide by infinity

Did you look at the following blog article?
| 1 Replies | 5668 Views | Created by r_laws - Monday, April 2, 2007 5:13 PM | Last reply by Robert Bruckner - Thursday, April 5, 2007 3:18 AM

### Dividing by Zero

the first record of the table and divide all the rest of the records by the data in the first record.  The problem comes when that first record contains zeros.  I used NullIf to ...
| 2 Replies | 4414 Views | Created by homeguards - Tuesday, October 14, 2008 6:49 PM | Last reply by BeforeAndAfter1974 - Tuesday, October 14, 2008 6:55 PM

### Divide by zero

Hi, i'm new to mdx and as.... And i'm geting a INF value in a KPI value because of a divide by zero. My KPI Value ...
| 2 Replies | 4508 Views | Created by clay123123123 - Wednesday, November 11, 2009 4:16 AM | Last reply by Deepak Puri - Wednesday, November 11, 2009 4:55 AM

### Divide Rows

IF you only want to assign the rows with some same value to each group then try this : SELECT *,(col-1) / @input FROM yrtable Or if you want ...
| 6 Replies | 1093 Views | Created by Jitta Rohan - Wednesday, January 9, 2013 6:51 AM | Last reply by Jitta Rohan - Wednesday, January 9, 2013 8:14 AM