No announcements

### Can we sum avg values in ssas

Hi all we are having values from Jan2011 to dec 2011..for 2011 we are taking the avg of all the months to get 2011 total.. Similarly for other ...
| 4 Replies | 2737 Views | Created by Bharath_RAM - Tuesday, July 19, 2011 12:05 PM | Last reply by Naveen Das - Tuesday, July 19, 2011 3:51 PM

### SELECT SUM and AVG

I have a statement that i am doing the following:   select sum(case when type='A' then xqty else 0 end), sum(case when ...
| 2 Replies | 4566 Views | Created by Darin Horton - Friday, April 8, 2011 8:10 PM | Last reply by Darin Horton - Friday, April 8, 2011 8:23 PM

### SQL SUM and AVG together

User135048391 posted Hi... Is it possible to include both SUM and AVG together in a single query ...
| 3 Replies | 64 Views | Created by Anonymous - Tuesday, July 12, 2011 12:32 PM | Last reply by Anonymous - Tuesday, July 12, 2011 2:12 PM

### AVG of SUM in MDX ?

Could you generate a set of the Products per order? You could then get the count of the members in the set and divide the sum of the sales by the ...
| 2 Replies | 1468 Views | Created by Esteban Zimanyi - Wednesday, April 10, 2013 1:57 PM | Last reply by Esteban Zimanyi - Thursday, April 11, 2013 9:52 AM

### AVG perform the SUM!!

The AVG function in MDX calculates the average of the set in the first parameter. Your set contains a single tuple therefore the average and the sum will always be ...
| 10 Replies | 4950 Views | Created by nko83 - Tuesday, June 7, 2011 1:17 PM | Last reply by nko83 - Wednesday, June 8, 2011 11:24 AM

### Custom Measure Issue (Avg,Sum)

Can you share the definition of the custom Measures that has Avg and Sum?-Remember to mark as helpful/the answer if you agree with the post.
| 3 Replies | 5359 Views | Created by Parth Rawal - Wednesday, May 11, 2011 1:10 PM | Last reply by Naveen Das - Wednesday, May 11, 2011 2:39 PM

### AVG and Sum function

, null, 1 UNION ALL select 'Q1', null, 5, 4, 4, 3 UNION ALL select 'Q2', 2, 2, null, 2, 2 select QTR, avg(val) avg_val from @t t unpivot ( val for c in ...
| 6 Replies | 1408 Views | Created by Vaishu - Thursday, December 20, 2012 4:01 AM | Last reply by Jackson_1990 - Thursday, December 20, 2012 4:32 AM

### T-SQL Challenge - sum/avg

As Sarat noted, it's not possible.  You can have different values in InitialFacts which create identical results in FinalFacts, but when computing the result ...
| 5 Replies | 1405 Views | Created by SnowShine429 - Sunday, November 24, 2013 5:48 PM | Last reply by --CELKO-- - Sunday, November 24, 2013 11:02 PM

### Sum in SSAS cube

Hi all, In SSMS, by executing the following query I was getting the result as 21556.36 select sum(amount) from ...
| 3 Replies | 6301 Views | Created by sudhirsvs - Tuesday, January 11, 2011 6:41 AM | Last reply by sudhirsvs - Tuesday, January 11, 2011 10:05 AM

### Distinct AVG or SUM in MDX

Weight] - using Sum aggregation on the SalesLineTotal_EqWeight Now you're [AVG Order Total Sum] and [SUM Distinct Order Total Sum] are much ...
| 1 Replies | 876 Views | Created by z97l - Friday, January 30, 2015 5:53 PM | Last reply by BillAnton - Friday, January 30, 2015 8:14 PM

### Distinct Sum in SSAS/MDX

Hi, I am trying to get distinct sum in SSAS/mdx. Can someone please give me an example on how this ...
| 2 Replies | 1567 Views | Created by Mayank.Jain - Monday, November 17, 2014 6:24 PM | Last reply by Mayank.Jain - Sunday, December 7, 2014 10:12 PM

### AVG From sum of seconds

the average of the nonempty values of cells in the specified set by first calculating the sum of values across cells in the specified set, and then ...
| 12 Replies | 688 Views | Created by sz1a - Thursday, January 19, 2017 3:53 PM | Last reply by sz1a - Tuesday, January 24, 2017 9:36 AM

### Exclude NULL values from SUM and AVG calculation

Hi, I have column in report that contains some NULL values. When i perform SUM,MAX,MIN or AVG calculation on this column the NULL ...
| 14 Replies | 29308 Views | Created by Oliver S D - Tuesday, October 21, 2014 11:45 AM | Last reply by Roger Willcocks - Wednesday, February 7, 2018 2:09 AM

### loop through repeater and avg or sum values

User1648350404 posted You can add class (say payToSum) and use jQuery to sum var totalPay = 0; \$(".payToSum").each(function(i) ...
| 2 Replies | 16 Views | Created by Anonymous - Monday, October 22, 2012 9:05 PM | Last reply by Anonymous - Tuesday, October 23, 2012 2:21 AM

### AVG Function using Calculated Measure in SSAS

suggested approach, I find that the output AVG from SSAS counted NULL amounts/values as a row...How do I get rid of it in the expression or configure it the ...
| 6 Replies | 7530 Views | Created by SSASNewBee - Friday, August 28, 2009 12:24 AM | Last reply by SSASNewBee - Thursday, September 3, 2009 6:24 PM

### T-SQL Sum, Avg, etc

I want to be able take v1, v2, v3 and v4 and add them. So far all the examples that use SUM you add the numbers in more then one row... what if you want to add the numbers across the ...
| 1 Replies | 2 Views | Created by Anonymous - Wednesday, October 31, 2007 4:03 PM | Last reply by Anonymous - Wednesday, October 31, 2007 4:52 PM

### Can you have a fact table with specified values at rollup levels instead of calculated?

;Sum", "Avg" etc. functions.  We now have a situation where our client wants to track actual stock turn against a budgeted stock ...
| 2 Replies | 3255 Views | Created by Ina Nortje - Monday, September 26, 2011 8:06 AM | Last reply by Ina Nortje - Wednesday, October 5, 2011 5:48 AM

### how can we use normsinv in SSAS

how can we use normsinv function in SSAS ? i want to calculate sigma level for activitiesGuneet Kalra
| 8 Replies | 3617 Views | Created by GUNEET KALRA - Tuesday, October 16, 2012 2:44 PM | Last reply by Elvis Long - Saturday, October 20, 2012 7:44 AM