Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Report Rate Topic Display Mode Topic Options
Author
 Message
 Posted Friday, May 15, 2009 2:10 PM
 SSC Rookie Group: General Forum Members Last Login: Saturday, January 21, 2012 2:04 PM Points: 27, Visits: 31
 Assume 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 question
Post #718278
 Posted Monday, May 18, 2009 4:35 AM
 SSCertifiable Group: General Forum Members Last Login: 2 days ago @ 11:24 AM Points: 6,979, Visits: 6,129
 This 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. Brandie Tarvin, MCITP Database AdministratorWebpage: http://www.BrandieTarvin.netLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #718919
 Posted Wednesday, May 20, 2009 9:30 PM
 Ten Centuries Group: General Forum Members Last Login: Wednesday, December 18, 2013 3:37 PM Points: 1,042, Visits: 2,690
 Must be finals week Tim Mitchell, SQL Server MVPIndependent Business Intelligence Consultantwww.TimMitchell.net@Tim_Mitchell
Post #721084
 Posted Wednesday, May 20, 2009 9:34 PM
 SSC Eights! Group: General Forum Members Last Login: Friday, October 18, 2013 12:13 PM Points: 951, Visits: 1,011
 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?
Post #721087
 Posted Thursday, May 21, 2009 5:02 AM
 SSCertifiable Group: General Forum Members Last Login: 2 days ago @ 11:24 AM Points: 6,979, Visits: 6,129
 Tim Mitchell (5/20/2009)Must be finals week I didn't even think about that. You're probably right. @=) Brandie Tarvin, MCITP Database AdministratorWebpage: http://www.BrandieTarvin.netLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #721227

 Permissions

 Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.