No announcements

### Trying 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.
| 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

### 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.
| 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

### 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.
| 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

### 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 ...
| 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

### Percentage of Row Total Calculation

I'm having an issue with the "show as % of row total" option in my pivot table.
| 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

### 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.
| 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

### 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 ...
| 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

### 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.
| 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

### Only ASP.Net Gridview or Gridview with JQuery

We are planning to implement .net gridview.
| 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

### 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.
| 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

### Calculating percentage

Get total Hibernated hours*/ UPDATE #hibernatetemp SET total_hibernate_hrs = DATEDIFF(MINUTE, on_time, hibernate_time)/ 60.0 /** Get total Sleep ...
| 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

### Calculating Percentage

Hi Mustafa, you don't need to update an extra column to do this. you can use a CTE instead.
| 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

### 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.
| 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

### 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 ...
| 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

### How to calculate percentage in MDX

[Percentage] AS IIF ( ([Measures].
| 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

### Calculating percentage using aggregate data?

Hi VM, In order to handle this you will have to create a calculated member named [fail rate percentage].
| 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

### calculate cumulative percentage change using MDX

I am not sure if I totally understood what you are asking for.
| 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

### 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 ...
| 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