No announcements
Found 2280564 threads
-
0 VotesDivision result is very small, always shows as 0
So, for sake of argument: VULNS = 111 LOC = 2000 Result = .0555 Is there a way to show 5.55/100 instead of ...Answered | 6 Replies | 343 Views | Created by Anonymous - Wednesday, January 8, 2020 4:49 PM | Last reply by Anonymous - Thursday, January 9, 2020 1:52 PM
-
0 Votes
division to return null when null else 0 if division occurs by 0
1 THEN [ItemNum] ELSE NULL END) AS FLOAT) ,0) / nullif(cast(count([ItemNum]) AS FLOAT),0) END AS 'value' FROM #sample b WHERE [Customer] LIKE 'abc%' AND YrMonth ...Answered | 9 Replies | 716 Views | Created by msdnpublic1234 - Monday, May 4, 2020 2:05 PM | Last reply by msdnpublic1234 - Monday, May 4, 2020 8:28 PM -
0 Votes
Handling Division by 0 in Format string in Calculation SSAS
[M2] =0 , null, [Measures].Answered | 5 Replies | 6610 Views | Created by Tanmoy Santra - Sunday, June 3, 2012 4:59 AM | Last reply by Manoj A - Saturday, June 9, 2012 10:06 AM -
1 Votes
Help Avoiding the Division by 0 Error
Use NULLIF trick, which is very common to avoid this problem.Answered | 2 Replies | 975 Views | Created by IndigoMontoya - Wednesday, November 20, 2013 7:54 PM | Last reply by Naomi N - Wednesday, November 20, 2013 8:05 PM -
3 Votes
Integer division
The result is always exact a number, which can be compared.Answered | 4 Replies | 4648 Views | Created by Vishruth Vasistha - Thursday, April 7, 2011 7:22 AM | Last reply by Vishruth Vasistha - Thursday, April 7, 2011 9:23 AM -
4 Votes
Checking for division by zero
Now you won't get a division by 0 error and you know that the results with a NULL value had 0 for Column2.Answered | 4 Replies | 2182 Views | Created by Haxton Fale - Thursday, August 2, 2012 1:49 PM | Last reply by Chris Sijtsma - Thursday, August 2, 2012 3:34 PM -
0 Votes
Calculation Routine to avoid division through 0
WITH //* Avoiding Error by DIVISION through NULL or 0 = give NULL to cell MEMBER [MEASURES].Answered | 9 Replies | 3773 Views | Created by Tobi-Ger - Friday, January 20, 2012 9:36 AM | Last reply by Tobi-Ger - Thursday, February 2, 2012 3:05 PM -
0 Votes
Percent Change Division Problem
When you perform division in SQL Server, the data type / precision of the result is the same data type / precision of the most precise data type in the equation.Answered | 1 Replies | 1343 Views | Created by Lindsey H - Tuesday, April 2, 2013 7:52 PM | Last reply by Samuel Lester - MSFT - Tuesday, April 2, 2013 8:12 PM -
0 Votes
Make sure a time in divisible by 5
Should work in all scenarios to round off to the nearest minute divisible by 5.Answered | 6 Replies | 6027 Views | Created by TheLearner - Wednesday, January 20, 2010 4:29 PM | Last reply by Sharad Nair - Wednesday, January 20, 2010 5:44 PM -
0 Votes
UploadChangesTotal is always being set to 0
ProjectName=sync&ReleaseId=3423 should have the results set correctly.Answered | 1 Replies | 6999 Views | Created by Varde - Tuesday, March 29, 2011 3:37 PM | Last reply by jigu2014 - Tuesday, March 29, 2011 4:52 PM -
7 Votes
Help with Division Calcualtion
With only ints, you get integer division.Answered | 8 Replies | 1049 Views | Created by Bone_12 - Thursday, January 10, 2019 11:09 AM | Last reply by Erland Sommarskog - Thursday, January 10, 2019 10:31 PM -
1 Votes
How to Sum a division using MDX
It can be very difficult to work out the granularity that you want the calculation to take place at.Answered | 12 Replies | 1789 Views | Created by CBatWork - Monday, November 9, 2015 3:51 PM | Last reply by CBatWork - Friday, November 13, 2015 6:39 PM -
0 Votes
Very very small question
That's the reason you are not getting any result set when you are using and condition.Answered | 7 Replies | 1468 Views | Created by S K M Naidu - Friday, October 4, 2013 2:40 PM | Last reply by udhayan - Saturday, October 5, 2013 8:40 AM -
0 Votes
Division not giving the correct number
As both operands are int, result gets converted to int That's not a really correct description.Answered | 5 Replies | 660 Views | Created by bk6741 - Monday, January 8, 2018 3:16 PM | Last reply by Erland Sommarskog - Monday, January 8, 2018 11:06 PM -
1 Votes
Primary Division
Primary Division: Write a program that will do the following: Prompt the user for two numbers.Answered | 2 Replies | 1007 Views | Created by LHoughton47 - Tuesday, October 7, 2014 6:29 PM | Last reply by Nonki Takahashi - Friday, October 10, 2014 2:54 AM -
2 Votes
Trying to divide a smaller number into a bigger number but the value always shows up as 0
boss, if u give as 2/100 then it will consider that as division of 2 int no and return 0 from 0.02...Answered | 3 Replies | 5181 Views | Created by cheatcountry - Tuesday, December 13, 2011 6:24 AM | Last reply by Shkumar - Tuesday, December 13, 2011 6:36 AM -
0 Votes
integer division negative numbers
Duplicate of already answered question atAnswered | 2 Replies | 4049 Views | Created by EvenAn - Monday, May 9, 2016 8:38 AM | Last reply by RLWA32 - Monday, May 9, 2016 5:28 PM -
0 Votes
A very small question on excel
Expression is : "C:\\"+ (DT_STR,4,1252) DatePart("yyyy",getdate()) + Right("0" + (DT_STR,4,1252) ...Answered | 6 Replies | 1611 Views | Created by Achilles33 - Wednesday, February 27, 2013 3:07 PM | Last reply by Dinesh Menon - Wednesday, February 27, 2013 5:40 PM -
1 Votes
Issue with "decimal" type and division
The numbers involved, unfortunately, ranged from small to large and using Decimal fields in the computation led to either roundoff or truncation error.Answered | 11 Replies | 8001 Views | Created by edm2 - Thursday, January 31, 2013 5:18 AM | Last reply by Tom Phillips - Thursday, January 31, 2013 9:32 PM -
0 Votes
Reporting navigator show 0 of 0
Browsing a report from Report manager / Report server always show page 0 of 0 in the tool bar Interactive sorting in ...Answered | 1 Replies | 1195 Views | Created by Soonyu - Thursday, April 30, 2015 9:07 AM | Last reply by Vicky_Liu - Friday, May 1, 2015 5:08 AM - Items 1 to 20 of 2280564 Next ›
No announcements
