.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Post New Web Links

How do I calculate Runningvalue percentage

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server

How do I calculate the running value percentage in a matrix

The Cumulative Frequency has been calculated as   =runningvalue(fields!recordcount.value,sum, nothing)

The Cumulative Frequency % is what I did not know how to calculate. 

Below is detailed view of my report

the field in my table for total record count is recordcount the other 3 are calculated fields on the report

View Complete Post

More Related Resource Links

Use one cell`s value onto aother Cell to calculate percentage in SSRS 2008


Pls help me with my below issue.


I developed SSRS 2008 Matrix Report.

In one of the Rows in the Matrix, First Rows Represent Percentage of Subtotal of Second Rows's Value.In my Matrix , total i have 4 Rows, one of Row need to show a Percentage of Subtotal of Another Row.

How can i Reference that Row Values / Matrix subtotal Values Like that ?

Below is formate of my Matrix SSRS 2008 Report.

Jan Feb March

Mumbai 48% 51% 41% <---Represent of Second Row - Bangalore Percentage of Subtotal

Bangalore 135 192 197

Delhi 149 185 278

Total 284 377 485

How can i reference, One Cell Value from other Cell's and Subtotal for the Percentage Calculation in SSRS 2008 Matrix ?

I would like to calculate percentage for banglore. Such as 135/284.. do you kno what i mean.

Please help me!!

Let me know if need information.



How to Define a "Total" to Calculate Percentage for SKU in PivotTable?


Let's take a look at a sample PivotTable below:


SKU     $     NewMeasure

111     5      30 (5+ 10 + 15)

222     10     30 (5+ 10 + 15) 

333     15     30 (5+ 10 + 15)

SKU     $     NewMeasure

111     5      20 (5+ 15)

333     15     20 (5+ 15)


How do I go about defining the "NewMeasure" calculated member in my AS2008 Enterprise cube?  The NewMeasure should essentially be the total $ amount for all SKUs in the current PivotTable.

What I'm really after, in this particular example, would be the percentage of a given SKU's $ amount relative to the total $ amount for all SKUs in the current pivot.  I figured if I can get the "NewMeasure" logic figured out, the above would be easy.

In summary, my goal is:

SKU     $     NewMeasure         NewMeasure2

111     5      30 (5+ 10 + 15)    5/30


Calculate distance, bearing and more between Latitude/Longitude points

This page presents a variety of calculations for latitude/longitude points, with the formulæ and code fragments for implementing them.

All these formulæ are for calculations on the basis of a spherical earth (ignoring ellipsoidal effects) - which is accurate enough* for most purposes. [In fact, the earth is very slightly ellipsoidal; using a spherical model gives errors typically up to 0.3% - see notes for further details].

How to calculate the distance between two points on the Earth

We offer many Global Database Products that you can use with the below formulas to calculate distances and many other uses. Not sure how to use distance calculations or global databases within your company? See our Global Database Examples for more information on how to use our data within your industry. Be sure to Download a Free Sample of one of our many Global Database Products.

Logic to calculate business hours


Hi All,

I have tried searching all over the web for this logic. Got many but half of them did not match what i was looking for and half were malfunctioning.

I want to calculate business working hours between 2 datetime, where in I should be able to set the working hours as well as weekends and holidays should not be calculated.


Please help me guys... It will be a great help... 

Calculate Client Height in javascript

The article Calculate Client Height in javascript was added by amoljk2009 on Monday, May 31, 2010.

Hi, Following code will help the developer to calculate exact client height in all browsers.script language="javascript" type="text/javascript">var winW = 630, winH = 460;if (parseInt(navigator.appVersion)>3) {if (navigator.appName

calculate fields in a list



how do I go about generating formulas for something like this.

I have a field( choice ) that has three choices (Low, Medium and High ). If I choose Low, I need to add 5 days to the current date( excluding weekends ) and place it in the Target date field, the same goes for Medium = 3 days( exclude weekends) , High = 1 day, exclude weekends.



KPI to calculate list item clicked most ?


Hello All:

Is there anyway where we can use KPI list to attach to a SharePoint list and indicates which item was clicked the most ? Or any other way to find out the best 5 links based on how many times they were accessed by a user?


Thanks in advance

SharePoint Developer

Reports in Percentage

Hi ALL, I have scheduled hours of each employee for each week and no of days scheduled in a week.i want to get reports for weekly wise no of employees scheduled less 24 hrs per week,b/w 24 and 48 hrs and greater than 48 hrs       Scheduled Hrs              8/1/2010         8/8/2010        15/8/2010            22/8/2010 Less than 24 hrs               5%                      5%                       5%                          4%   b/w 24 and 48 hrs          4%                        6%                    &

Calculating percentage of sceduled hours

 Hi all,       I want to calcultae how many employees are scheduled less 24 hrs for each week,b/w 24 and 48 and greater than 48         In excel file i have weekly wise total hours scheduled for each employee  and total no of days scheduled in week(example 6 days and 1 off)which i will upload it to database,based on this i want to display reports  in bound controls Result should be like this                    Scheduled Hrs      8/1/2010        8/8/2010       8/15/2010       8/22/2010                  Less than 24 hrs     5%                       5%                  5%                   5%        Between 24 and 48 hrs    5%         

Performance Problems with calculate member in a cube

Hi,  I'm having performance issue with calculated member (Running total) which is created on one dimension in the cube.  Cube is having three dimension Product Details(Product Model, Product Type) , Time(Year & Month) & Qty type(In Qty & Out qty). See below for details Dimtime Year (Values 2000 to 2020) Month DimProd Product No Product Type Product Group DimQty Type In Qty Out Qty Fact Table Product No Year Month Qty Type of Qty( In Qty or Out Qty ) My MDX query for calculated member is  CREATE MEMBER [Qty Type].[Qty Type].[All].[Total] as      SUM(NULL:[TimeDim].[Hierarchy].CurrentMember , ([Qty Type].[Qty Type].[In Qty], Measures.[Qty]) - ([Qty Type].[Qty Type].[Out Qty], Measures.[Qty])  The formula is --> Total = Previous Period Total Qty + Inqty - Out Qty   This works perfectly when i browse at higher level (Qty Type on Rows & Time On Columns),   but when  i browse the cube adding dimension Product Details( Product group or Product Type) to Drill-through the In Qty & Out Qty,  the query is running and after one hour also it's not finished. Can anyone help me to solve this or propose new structure to resolve this issue.   

wrong Percentage calculation showing in pie chart

Hi,       Im using "#PERCENT{P2}" this one to calculate percentage in pie chart.  It should take 2 decimal only rite? But it is taking 3 decimal values. Example: 20.90678 After applying the formula "#PERCENT{P2}"  it is showing as 20.91 i want to show as 20.90 only pls help me Thanks in advance, Abdul2010

how i can calculate date difference in oracle

how i can calculate the date diff in Oracle 10g using pl sql developer 7thank you

Two many to many dimension => How to calculate correct facts????

Hey guys,   I got a problem and I hope someone could help me with it.  I have the following scenario which I need to solve. The Schema looks something lilke that...   DIM3 DIM3_Key Dim3_Att   FactlessFact_DIM3_DIM4 DIM3_Key DIM4_Key WeightingFactor   DIM4 DIM4_Key Dim4_Att     FACT DIM1_Key DIM3_Key Sales_Fact   DIM1 DIM1_Key Dim1_Att   FactlessFact_DIM1_DIM2 DIM1_Key DIM2_Key WeightingFactor     DIM2 DIM2_Key Dim2_Att   As you can see my Facttable is connected to two dimension which are actually many to many. Also there is a 'WeightingFactor' in every FactlessFact table (BRIDGE), so that i am able to correct (as defined by the factors) values when ever I query DIM2_Att or DIM4_ATT.   So the Problem I have is that I every Fact shoud be MULTIPLIED with the WEIGHTING FACTOR. Well in MSAS 2008 I can do that with an Measured expression but since a measure needs to be unique I cannot just use 'WeightingFactor'. So When I renamed it to WeightingFactor34 and WeightingFactor12. But this only gives me the correct values for the defined Path. In case I use  WeightingFactor12 i only get the correct values for DIM2_ATT but not for DIM4_ATT.   I guess I need to solve this with a calculated Measure???? Am I right? I am new to MSAS and also new with MDX and all this stuff... How can use a calculated meas

MDX Calculation to calculate Rank

Hi all, I am trying to calculate rank of the objects based on sales. It should only change for date dimension. For all other dimension attributes, it should remain the same. Please help me out. Thanks, Sam  

Percentage of matching days off among employee's

Hi All,i have Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday). I want result in percentage.result like thisConsistency Days of assignment            Across 4 weeks            3 weeks                2weeks                0                                                             2%                                   0%     &

Pie show percentage greater than 100%

Hi all , i have a pie chart and show percentage as label ,i set label data as #PERCENT{P0} but when report runs it has 3 value: 58%,11%,32% you can see the 3 value add up to 101% is something else i need to set on label ? any help for this ?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend