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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculated member - conditional sum
Justin, Sorry for this confusion. Your first statement is correct: count the number of order id's where the actual finish date <= deadline date. Afterwards, I can calculate the following ratio: (Nbr of Id's where the actual finish date <= deadline date)/ (total nbr of Id's) This ratio is...- cubes
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Calculated member - conditional sum
Hi, considering two dates: the actual finish date and the deadline; and the dimension "id" (order id) Calculation to do > SUM of all id's prerequisite: actual finish date <= deadline Which value expression do I need to define in the "calculated member builder"? Shall I define the dates as...- cubes
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
