No announcements

### Calculating Sum fo Squares over a period

the correct values for individual months. However, I need to calculate the sum of the individual month squares over each year (or any other specified period for ...
| 5 Replies | 7137 Views | Created by Colin Banfield - Friday, January 22, 2010 6:07 PM | Last reply by Marco Russo - Monday, January 25, 2010 1:31 AM

### Calculating Distinct Count over a period of 3 consecutive years

Hello, I have the need to calculate a distinct count over a period of 3 years.  I use the MDX ...
| 5 Replies | 723 Views | Created by Sharkybi - Tuesday, August 11, 2015 3:55 AM | Last reply by Simon_Hou - Monday, August 17, 2015 4:40 AM

### Period over Period

dimensions) and also select a comparison timeframe (None, Period-Over-Period, Year-Over-Year, Date Range).  The goal was to develop ...
| 9 Replies | 9363 Views | Created by dcb98 - Tuesday, October 9, 2007 5:00 PM | Last reply by Gene77532 - Thursday, August 25, 2011 11:31 AM

### Calculating database and server growth over five year period

Hi Is there an easy way to calculate the database growth over a 5 year period? We are warehousing data and I have been asked to provide ...
| 1 Replies | 4097 Views | Created by dev-13 - Wednesday, November 7, 2012 5:42 PM | Last reply by Rama Udaya - Thursday, November 8, 2012 3:54 AM

### problem in calculating sum for a column

3        1 im calculating sum of col1,col2 and ...
| 2 Replies | 5269 Views | Created by Bhaskar Ravindranath - Sunday, April 13, 2008 7:46 AM | Last reply by Bhaskar Ravindranath - Sunday, April 13, 2008 8:45 AM

### Calculating Cumulative Sum

, a.proddate , SUM(b.marks) markssum, SUM(b.marks1) marks1sum FROM #RAP a, #RAP b WHERE a.zone =b.zone and a.firstdate=b.firstdate and b.proddate
| 8 Replies | 801 Views | Created by Abhinav530 - Thursday, January 8, 2015 11:00 PM | Last reply by Jingyang Li - Friday, January 9, 2015 3:45 PM

### Sum of Months period <> Quarter period etc...

amount spend in the previous period over corrected plan and in the current period is now lowering original plan. It looks like ...
| 1 Replies | 5031 Views | Created by Elvar - Tuesday, May 10, 2011 5:54 PM | Last reply by Elvar - Wednesday, May 11, 2011 9:42 AM

### sum() over

,         (SLEECT SUM(a.sumwork)          FROM   CTE b       ...
| 11 Replies | 2608 Views | Created by Sunette - Tuesday, October 23, 2012 10:59 AM | Last reply by Erland Sommarskog - Tuesday, October 23, 2012 12:57 PM

### Calculating MTD, MTD Prior Period -

I need to calculate the MTD and MTD Prior Period..QTD..YTD etc. for all the measures; Below is the code snippet: For designing a PPS report, My requirement is to ...
| 1 Replies | 5787 Views | Created by satishjain - Friday, November 13, 2009 5:12 AM | Last reply by Raymond-Lee - Tuesday, November 17, 2009 3:21 AM

### Calculating Sum Based on condition

DECLARE @martialLaw TABLE (sequence INT, length INT) INSERT INTO @martialLaw (sequence, length) VALUES (1, 10),(2, 20),(3, 30),(4, 40),(5, 50) SELECT *, (SELECT SUM
| 1 Replies | 626 Views | Created by Abhinav530 - Thursday, March 19, 2015 8:01 PM | Last reply by Patrick Hurst - Thursday, March 19, 2015 8:12 PM

### Calculating sum through trigger.

sub1 + sub2 + sub3 + sub4 + sub5) AS subject _total  The additon will return a NULL as long
| 5 Replies | 7154 Views | Created by ankitguptajpr - Sunday, October 17, 2010 11:47 AM | Last reply by --CELKO-- - Monday, October 18, 2010 6:22 PM

### Calculating sum based on date

create a formula... year({your_date_field}) group by that field and insert a sum in the group footer. Or, if you need to keep ...
| 1 Replies | 3807 Views | Created by Marina2042 - Friday, January 18, 2008 2:37 PM | Last reply by [_Joe_] - Friday, January 18, 2008 2:52 PM

### Comparing Sets over a period of Time

Partner, wich associates the Partner with a specific Sale - There's Measure for Distinct Count of the Partners - There's a Fiscal Calendar Time ...
| 1 Replies | 4749 Views | Created by Rafael Veronezi - Tuesday, October 27, 2009 1:33 PM | Last reply by Raymond-Lee - Thursday, October 29, 2009 7:43 AM

### Calculating sum of customMeasurements items.

Is there a way to summarize customMeasurements items and sum up the count associated with each item. Example: my customMeasurements are:
| 2 Replies | 573 Views | Created by mpnap - Friday, October 14, 2016 8:50 PM | Last reply by Dmitry G Matveev - Saturday, October 15, 2016 12:20 AM

### Calculating an Average of an Average over a Fiscal Year Time Period

I now need a YTD average of the average time period. So for example for February I need the sum of the Average EOP HC for every single month (Jul - Feb) and then I ...
| 3 Replies | 843 Views | Created by Bee_17 - Friday, March 9, 2018 10:26 PM | Last reply by allmhuran - Monday, March 12, 2018 5:26 AM

### Calculating Sum of First values.

, you can add a page break for the parent group so that each child group can be placed in one page, then enable the page footer and type an expression like ...
| 12 Replies | 10075 Views | Created by Igor Gelin - Friday, August 13, 2010 9:11 PM | Last reply by Manuel Luna - Thursday, September 2, 2010 4:11 PM

### problem with calculating sum of large nos

hello all   i am calculating sum of very large nos using sum function of SQL. but the final result i get is incorrect. i am using SQL server 2000. like value ...
| 2 Replies | 10204 Views | Created by vignesh_b - Friday, October 28, 2005 9:57 AM | Last reply by Andreas Johansson - Friday, October 28, 2005 11:21 AM

### Calculating the Sum of a Measure over rolling 6 months in PowerPivot

I am trying to calculate the sum of gross sales over a rolling 6 month period in PowerPivot and don't even know how to start.
| 2 Replies | 837 Views | Created by Ball in da Bay - Monday, May 4, 2015 6:13 PM | Last reply by Ball in da Bay - Monday, May 4, 2015 11:59 PM