Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Make Avg() on filtered data
Hi, I need help in this problem. For example I have the query below in Web Components Calendar Price Avg 200505 50 200506 23 200507 45 200508 33 200509 23 200510 56 200511 32 200512 12 30,75 <<--- Calculated Member Avg = (12 + 32 + 56 + 23) / 4 = 30,75 Calculated Member MDX...- gbim
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Error Counting Dimension Level in Calculated Member
I have a calculated member with the following expression: iif(Count(Descendants([Cp Date].CurrentMember, [Cp Week]))<>0, [Measures].[Ocp Css] / Count(Descendants([Cp Date].CurrentMember, [Cp Week]),INCLUDEEMPTY),0) Basicaly this have to make a division between the measure "Ocp Css" with the...- gbim
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
