InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 22:20:29 GMT20http://www.sqlservercentral.com/Forums/Topic718278-147-1.aspx[quote][b]Tim Mitchell (5/20/2009)[/b][hr]Must be finals week :w00t:[/quote]I didn't even think about that. You're probably right. @=)Thu, 21 May 2009 05:02:33 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic718278-147-1.aspx[font="Verdana"]Are we talking a SQL Server T-SQL formula, or a SQL Server Analysis Services MDX formula, or a SQL Server Reporting Services inline formula or a VB.Net formula or an Excel formula or a Crystal Reports formula or...Also, what have you already tried? What is your definition for the value you want?[/font]Wed, 20 May 2009 21:34:49 GMTBruce W Cassidyhttp://www.sqlservercentral.com/Forums/Topic718278-147-1.aspxMust be finals week :w00t:Wed, 20 May 2009 21:30:48 GMTTim Mitchellhttp://www.sqlservercentral.com/Forums/Topic718278-147-1.aspxThis sounds suspiciously like a homework or test question. We don't answer those on this site. It shouldn't be too hard for you to find the answer. Look up MDX in Books Online.Mon, 18 May 2009 04:35:22 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic718278-147-1.aspxAssume you have a report table (no Breaks) with the following Dimensions: State, County, and City with the measure, Population. Write a formula which caclulates the weighted average population of city divided by state.Please give me a solution to this questionFri, 15 May 2009 14:10:53 GMTkhasim76