No announcements
Found 3644454 threads
-
4 VotesTrying to use total query to calculate percentage of whole!
Given the parameter names are "StartDate" and "EndDate" the user will be prompted to enter these whenever the query is run.Answered | 4 Replies | 43429 Views | Created by krazykevin76 - Thursday, June 14, 2012 10:14 PM | Last reply by krazykevin76 - Thursday, June 14, 2012 11:17 PM
-
0 Votes
Calculated percentage of the total in mdx shows null in SSRS
Hi Franco, Please format the cell to type percentage and see if that resolves this.Answered | 1 Replies | 4543 Views | Created by Franco Lopes - Thursday, July 7, 2011 7:48 AM | Last reply by Shahfaisal Muhammed - Saturday, July 9, 2011 12:25 AM -
0 Votes
Running Total Percentage
However, as long as all values in the product are positive, we can use the fact that a*b = n^(logn(a) + logn(b)), which is what I use here.Answered | 6 Replies | 635 Views | Created by RamaRamaKK - Monday, February 22, 2016 8:20 PM | Last reply by Erland Sommarskog - Monday, February 22, 2016 11:15 PM -
1 Votes
calculate percentage of total for certain field type
Without knowing what your model looks like, or any sample data, I can't say that the formulae below will work exactly as written, but these should at least point you in the right ...Answered | 1 Replies | 883 Views | Created by ScottCabral - Friday, October 10, 2014 4:44 PM | Last reply by greggyb - Friday, October 10, 2014 4:56 PM -
0 Votes
Percentage of Row Total Calculation
I'm having an issue with the "show as % of row total" option in my pivot table.Answered | 2 Replies | 3265 Views | Created by John Newbie604 - Wednesday, January 23, 2013 7:19 PM | Last reply by Elvis Long - Friday, January 25, 2013 6:38 AM -
0 Votes
Percentage calculation using Calculated member
Hi Ramakrishnan, I am using similar to the following, can you use [Average Reseller Sales] in your example and run the following.Answered | 9 Replies | 2831 Views | Created by Sami-VA - Thursday, December 29, 2011 2:43 AM | Last reply by Ramakrishnan.lh - Friday, December 30, 2011 5:31 AM -
0 Votes
SSRS Question to calculate total Percentage
go to the properties --> select the number category to percentage. in this expression (textboxtotal is the textbox# where you get your ...Answered | 1 Replies | 4588 Views | Created by McDerface - Wednesday, April 20, 2011 6:21 PM | Last reply by Hardik Bhavsar - Wednesday, April 20, 2011 6:46 PM -
3 Votes
SSRS 2008 Matrix - Problem with Calculating Percentage using Sub Total
Using the examples here, we can get a figure that represents the percentage amount across the column group OR across the row group.Answered | 8 Replies | 12520 Views | Created by ArtSQL - Sunday, May 6, 2012 10:25 PM | Last reply by E3xtc - Monday, November 5, 2012 10:33 PM -
1 Votes
Only ASP.Net Gridview or Gridview with JQuery
We are planning to implement .net gridview.Answered | 1 Replies | 1949 Views | Created by Karthik Chennappan - Thursday, August 21, 2014 1:15 AM | Last reply by Cor Ligthert - Thursday, August 21, 2014 8:18 AM -
0 Votes
How to create a running percentage of total
Hi cmcmac, According to your description, you want to add a column to show the percentage value of the total values in the right of the value column.Answered | 1 Replies | 1024 Views | Created by cmcmac - Thursday, January 9, 2014 12:29 PM | Last reply by Katherine Xiong - Friday, January 10, 2014 8:24 AM -
2 Votes
Calculating percentage
Get total Hibernated hours*/ UPDATE #hibernatetemp SET total_hibernate_hrs = DATEDIFF(MINUTE, on_time, hibernate_time)/ 60.0 /** Get total Sleep ...Answered | 5 Replies | 3738 Views | Created by NT86 - Monday, June 14, 2010 3:40 PM | Last reply by NT86 - Wednesday, June 16, 2010 1:57 PM -
0 Votes
Calculating Percentage
Hi Mustafa, you don't need to update an extra column to do this. you can use a CTE instead.Answered | 4 Replies | 1300 Views | Created by MustafaH - Thursday, February 13, 2014 3:18 PM | Last reply by Kalman Toth - Thursday, February 13, 2014 4:26 PM -
0 Votes
Need to calculate percentage to plot delivered cases against total dispatches
However, i just got to know that I'll have to calculate the percentage number of days it has taken to be delivered.Answered | 9 Replies | 822 Views | Created by Sharaschandra - Tuesday, August 9, 2016 5:57 AM | Last reply by Sharaschandra - Friday, August 19, 2016 7:06 AM -
0 Votes
percentage calculation
Thats great I wasn't able to use percentage as the having clause in the first expression as you pointed out and did think of doing it as a 2nd CTE but was wondering if it could be ...Answered | 9 Replies | 7818 Views | Created by aivoryuk - Saturday, February 19, 2011 2:54 PM | Last reply by aivoryuk - Sunday, February 20, 2011 10:28 AM -
0 Votes
How to calculate percentage in MDX
[Percentage] AS IIF ( ([Measures].Answered | 7 Replies | 16466 Views | Created by Net2MDX - Wednesday, January 2, 2013 2:21 PM | Last reply by sudipta.2.ghosh - Thursday, January 3, 2013 9:18 AM -
0 Votes
Calculating percentage using aggregate data?
Hi VM, In order to handle this you will have to create a calculated member named [fail rate percentage].Answered | 1 Replies | 996 Views | Created by rbhatup - Monday, April 28, 2014 9:21 PM | Last reply by S Kamath - Tuesday, April 29, 2014 1:51 AM -
0 Votes
calculate cumulative percentage change using MDX
I am not sure if I totally understood what you are asking for.Answered | 2 Replies | 2494 Views | Created by ScottCabral - Wednesday, April 23, 2014 11:03 PM | Last reply by S Kamath - Friday, April 25, 2014 2:57 AM -
2 Votes
Percentage of total
Hi Syed This work really well but I do have another question now I also have a group category so that which category in which different product belong to and ...Answered | 4 Replies | 2906 Views | Created by Fidiausms - Tuesday, May 22, 2012 12:59 AM | Last reply by Fidiausms - Tuesday, May 22, 2012 10:01 PM -
0 Votes
Calculate Running Total For a Measure that Uses DATEADD
Solved it finally, by first calculating a Cumulated Total for the Units Bought, then shifting it using DATEADD, and first using an IF to display data only for the ...Answered | 3 Replies | 1263 Views | Created by Bond. James Bond - Saturday, February 27, 2016 7:38 PM | Last reply by Bond. James Bond - Monday, February 29, 2016 4:39 PM -
1 Votes
Calculate percentage
Hi Sqlakm, We can use custom code to do it.Answered | 3 Replies | 3188 Views | Created by sqlakm - Monday, May 27, 2013 7:12 AM | Last reply by Charlie Liao - Tuesday, May 28, 2013 6:25 AM - Items 1 to 20 of 3644454 Next ›
No announcements
